We have matrix report which has 3 levels of row grouping and 1 column grouping. I want to add a column outside column group to get the difference between one of the column that appears in the column group. The column group is by Year showing current year data vs last year. How do I get variance of one of the column in the column group in the scope of column group?
Here is what I tried.
1. Added a column outside column group
2. Have put the expression Var(field, "column_group_name")
Above results in error scope parameter is not valid for an aggregate function. How can I get this to work?