Well, if you select the dividend as the data field..
right-click in the data area, select Options...
show data as:
% of pick your base field.

Does that work for you?


"Diego" wrote:

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