G
Guest
I have a pivot in this format:-
Location Level 2004 2005 Total
north a 7 5 12
south b 6 2 8
east c 5 7 14
west d 20 13 33
northeast d 3 3 6
southwest a 15 10 25
southeast e 13 20 33
northwest c 15 14 29
Grand Total 84 74 160
I want a % column next to the Total column only like example
for north, (12/160) 7.50% and so on...(total/grand total for each location)
when i tried to add a calculated item by selecting the '% of Total' option,
i see the % values appearing below every location, which i want to avoid and
instead have the % column only next to the Total column.
Any ideas?
Thanks
Location Level 2004 2005 Total
north a 7 5 12
south b 6 2 8
east c 5 7 14
west d 20 13 33
northeast d 3 3 6
southwest a 15 10 25
southeast e 13 20 33
northwest c 15 14 29
Grand Total 84 74 160
I want a % column next to the Total column only like example
for north, (12/160) 7.50% and so on...(total/grand total for each location)
when i tried to add a calculated item by selecting the '% of Total' option,
i see the % values appearing below every location, which i want to avoid and
instead have the % column only next to the Total column.
Any ideas?
Thanks