View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Diego Diego is offline
external usenet poster
 
Posts: 2
Default % of subtotal custom calculation in a pivot table

hello everybody,

Debra Dalgleish mentions in her pivot table recipes book that although there
is no % of subtotal custom calculation available in a pivot table, one can
arrange fields in the row and column areas and then use % of row or % of
column to show these percentages. Does anyone know how to do this? Could you
provide a short example?

Microsoft should think about including this option in future Excel releases,
don't you think?
--
Thank you!

Diego