% 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
|