This Month € This Month Last Year € % Change Variance
Salesperson 100 110
Brand X 50
Brand Y 50
Product A 25
Product B 25
Product C 25
etc but I cannot get three groupings in a Matrox report on the left.
Is this possible or is there a way to be able to click through from the top level to more detailed levels ?
3 个回答
As you've seen, a Matrix report will only allow 2 levels of grouping. If you group by Salesperson and Product on the left, you can group by CloseDate (group by Month) and Brand on the top. This would give you the view you are looking for. Then, take a look at adding Formulas to the report, and especially the PREVGROUPVALUE() to get the matrix totals and percents.
