PivotTable-% of total
 

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

PivotTable-% of total
 

Hi

In PT, drag the Data button to the total area, and you should see the
results in a column

--
Regards

Roger Govier


"Minerva" wrote in message
...
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

PivotTable-% of total
 

Yes, it worked! Thanks

"Roger Govier" wrote:

Hi

In PT, drag the Data button to the total area, and you should see the
results in a column

--
Regards

Roger Govier


"Minerva" wrote in message
...
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