November 25, 2014 at 9:21 am
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?
Bhavesh
.NET and SQL Server Blog
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy