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?
