Niels Thomsen
Articles
-
Average each column (as a row)
Type: Inserted as a rowDescription: Calculates the average of all values in each column.Range:Columns: Each columnRows: All rowsMeasures: Each measureSyntax:avg(0, all, 0)Sample crosstab: ExampleHe...
-
Difference between current row and previous row (as a measure)
Type: Inserted as a measureDescription: Calculates the difference between two values, current row and previous row, in each column.Range:Columns: Each columnRows: Each row minus Previous rowMeasure...
-
Difference between current row and previous row (as a column)
Type: Inserted as a columnDescription: Calculates the difference between two values, current row and previous row, in last column.Range:Columns: Last columnRows: Each row minus Previous rowMeasures...
-
Difference between two measures (as a measure)
Type: Inserted as a measureDescription: Calculates the difference between two measures in each column.Range:Columns: Each columnRows: Each rowMeasures: First measure minus Second measureSyntax:sum(...
-
Difference between first column and second column (as a column)
Type: Inserted as a columnDescription: Calculates the difference between two values, first column and second column.Range:Columns: First column minus Second columnRows: Each rowMeasures: First meas...
-
Difference between last column and second last column (as a column)
Type: Inserted as a columnDescription: Calculates the difference between two values, last column and second last column.Range:Columns: Last column minus Second last columnRows: Each rowMeasures: Fi...
-
Accumulated sum from the left (as a measure)
Type: Inserted as a measureDescription: Calculates an accumulated sum of values from first column to each column.Range:Columns: From first column to each columnRows: Each rowMeasures: First measure...
-
Accumulated sum from the top (as a measure)
Type: Inserted as a measureDescription: Calculates an accumulated sum of values from first row to each row, in each column.Range:Columns: Each columnRows: From first row to each rowMeasures: First ...
-
Accumulated sum from the top (as a column)
Type: Inserted as a columnDescription: Calculates an accumulated sum of values from first row to each row, in last column.Range:Columns: Last columnRows: From first row to each rowMeasures: First m...
-
Total hidden values, each row (as a column)
Type: Inserted as a columnDescription: Calculates the sum of all hidden values in each row.Range:Columns: All columns (hidden)Rows: Each rowMeasures: First measureSyntax:sum(all(h), 0, m1)Sample cr...