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