software

I have a pivot in this format:-
LocationLevel20042005Total
northa7512
southb628
eastc5714
westd201333
northeastd336
southwesta151025
southeaste132033
northwestc151429
Grand Total8474160

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

Hi

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

--
Regards

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

quot;Roger Govierquot; wrote:

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