- Type: Inserted as a column
- Description: Calculates the difference between two values, last column and second last column.
- Range:
- Columns: Last column minus Second last column
- Rows: Each row
- Measures: First measure
- Syntax:
sum(d-1, 0, m1) - sum(d-2, 0, m1)- Sample crosstab:
Example
In the table above we want to calculate the difference between 2024 Revenue and 2023 Revenue - this is done by adding Difference last column - second last column (column).
Comments
Please sign in to leave a comment.