View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnB JohnB is offline
external usenet poster
 
Posts: 53
Default PivotTables and xlPercentOfTotal

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