View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot Table Percentages

There's no option to calculate the percent of a subtotal in a pivot
table. You could do the calculation outside of the PivotTable.

Les wrote:
Having read a few posts I realise what I am after is to be able to show
percentages for Sub-Totals as well as Grand totals when showing % of total. I
have read a post saying this is not possible, can anyone confirm this?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html