Niels Thomsen
Articles
-
Accumulated sum within each hierarchy group (as a column)
Type: Inserted as a columnDescription: Calculates an accumulated sum of values from first row to each row, within each hierarchy group, in last column.Range:Columns: Last columnRows: From first row...
-
Trailing 12 months average (as a measure)
Type: Inserted as a measureDescription: Calculates the average of 12 months' intervals - from any month (included) and 11 months back in time, in each column.Range:Columns: Each columnRows: 12 rows...
-
Trailing 12 months average (as a column)
Type: Inserted as a columnDescription: Calculates the average of 12 months' intervals - from any month (included) and 11 months back in time.Range:Columns: Last columnRows: 12 rows intervalsMeasure...
-
Accumulated average (as a measure)
Type: Inserted as a measureDescription: Calculates the accumulated average from the first row value to the current row value, in the range.Range:Columns: Each columnRows: From first row to each row...
-
Accumulated average (as a column)
Type: Inserted as a columnDescription: Calculates the accumulated average from the first row value to the current row value, in the range.Range:Columns: Last columnRows: From first row to each rowM...
-
Average each column (as a measure)
Type: Inserted as a columnDescription: Calculates the average of all values in each column.Range:Columns: Each columnRows: All rowsMeasures: First measureSyntax:avg(0, all, m1)Sample crosstab: Exam...
-
Average last column (as a column)
Type: Inserted as a columnDescription: Calculates the average of all values in last column.Range:Columns: Last columnRows: All rowsMeasures: First measureSyntax:avg(d-1, all, m1)Sample crosstab: Ex...
-
Average each row (as a column)
Type: Inserted as a columnDescription: Calculates the average of all values in each row.Range:Columns: All columnsRows: Each rowMeasures: First measureSyntax:avg(all, 0, m1)Sample crosstab: Example...
-
Average visible values, each column (as a row)
Type: Inserted as a rowDescription: Calculates the average of all visible values in each column.Range:Columns: Each columnRows: All rows (visible)Measures: Each measureSyntax:avg(0, all(v), 0)Sampl...
-
Average hidden values, each column (as a row)
Type: Inserted as a rowDescription: Calculates the average of all hidden values in each column.Range:Columns: Each columnRows: All rows (hidden)Measures: Each measureSyntax:avg(0, all(h), 0)Sample ...