- Type: Inserted as a column
- Description: Calculates first column value as index of second column value.
- Range:
- Columns: First column as index of Second column
- Rows: Each row
- Measures: First measure
- Syntax:
if sum(d2, 0, m1) = 0 then 0 else sum(d1, 0, m1) % sum(d2, 0, m1)
- Sample crosstab:
Example
In the table above we want to calculate the 2024 revenue index based on the 2023 revenue- this is done by adding Index first column based on second column (as a column).
Comments
Please sign in to leave a comment.