Matrix Subtotals
I looked at RS a couple years back, around the release of SP1.The biggest issue I had was the lack of Aggregates of Aggregates.This still seems to be the case in RS 2005, is that correct?
So help me with a work around.
In a Matrix report how can I?
Have a calculation (Aggregate) that has a scope that is for both the Row and the Column.
Example:
What is the percent of total sales and percent of total category sales?
Q1Q2Total
Beverages
Lemonade
Sales $100150250
Percent of Bev44%
Percent of Total19%?How do I do these Percentages in a Matrix?
Soda
Sales $125125250
Percent of Bev
Percent of Total
Total Beverages225275500
Snacks
Peanuts
Sales $100150250
Percent of Snacks
Percent of Total
Cookies
Sales $200250450
Percent of Snacks
Percent of Total
Total Snacks300400700
Total Sales5256751300
In RS 2000 you could not have an Aggregate of an Aggregate, nor could you have a “compound scope”.Because of this I went back to that other software.
I would love a way to deal with this, I have many reports that use this functionality, and would like to move to RS.If I could use the Matrix, I could author reports in 10% of the time.
Ideas?
