Create a 'All' or 'Total' row for each of the dimension groups

[hopkinsc]

Hi all,

can anyone tell me if its possible to create a new group called 'ALL' or 'Total' for each of the groups in my dimension in a straight table please and maybe add a total in after each group?

e.g.

Customer	Group	Value
Cust A	Group A	100
Cust B	Group A	200
Total		300
Cust A	Group B	50
Cust B	Group B	100
Total		150
Cust A	Total	150
Cust B	Total	300
Total		450

example attached.

[sunny_talwar]

Like this?

[hopkinsc]

that great for adding in the totals, but is it possible to add a total line for each of the rows, so the user can easily see the grand total for each customer without having to click the customer first?

[sunny_talwar]

Not sure I understand... how would that look?

[hopkinsc]

something like the attached..

[sunny_talwar · Accepted solution]

Check now

[hopkinsc]

In all fairness, you are just too helpfull

thanks so much