Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to show the values in my pivot table as 100% for each sub total
I need to show my pivot table like below
Cg1 | Cg2 | Expr1 | Expr2 |
---|---|---|---|
Total | 100% | 100% | |
xxx | aaa | 25% | 50% |
bbb | 25% | 30% | |
ccc | 50% | 20% | |
Total | 100% | 100% | |
yyy | ddd | 10% | 60% |
eee | 70% | 40% | |
fff | 20% | - | |
Total | 100% | 100% | |
zzz | ggg | 15% | 90% |
hhh | 75% | 10% | |
iii | 10% | - | |
Now I can show the partial total by doing the settings on Presentation tab.
My concern is I am getting the overall total as 100% but not the each sections total as 100%. The 100% should be shown for all fields in the cyclic groups.
So What should I do to get 100% value in each section??
Can anyone help me in this??
Thanks in Advance
Regards,
Leni
Thanks a lot for your helps