column dimension in a table

[jm1]

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

[jm1]

Hi All,

Any suggestions would be greatly appreciated?

Thanks