You can do this within a pivot as follows: dbl click on your data item in
wizard to see the pivot field popup screen then in the "show data as" drop
down select "% of total", click ok all the way out and your % of total colum
will be in your pivot table.

Hope this helps.
KD


"johnb" wrote:

so Hi All
Is it possible to have pivottable which has a Grand Total column and in the
column to the right have the same numbers shown as percentages. All in one
pivottable. So in effect there are 2 Grand Total Columns, 1 with numbers and
the other with percentages. I can only do currently using a 2nd pivottable.

If its possible then how?

TIA
johnb