Hi all,
I need to get a pivot table view without using a pivot table (due to the limited formatting options). What I am trying to do is show the following, where Account/Group and Company are separate dimensions:
| | Group | Company | | |
| Account | G1 | C1 | C2 | C3 |
| 1 | 100 | 5 | 5 | 90 |
| 2 | 10 | | 10 | |
| 3 | 120 | 20 | 60 | 40 |
| 4 | 50 | 10 | 20 | 20 |
| 5 | 60 | 10 | 15 | 35 |
| 6 | 80 | 40 | 20 | 20 |
| 7 | 5 | 5 | | |
The Group amount = C1 + C2 + C3. There are multiple Groups with different number of companies in each Group. I want the user to be able to select a Group and then it shows the breakdown of that Group next to it, but I dont know how I can achieve this in set analysis.
Does anyone have any ideas how I can achieve this without using a pivot table or drilldown dimensions?
thanks
