column dimension in a table

jm1 — Sat, 16 Nov 2024 21:13:30 GMT

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

Re: column dimension in a table

jm1 — Wed, 20 Mar 2019 08:04:49 GMT

Hi All,

Any suggestions would be greatly appreciated?

Thanks

topic Re: column dimension in a table in App Development

column dimension in a table

Re: column dimension in a table