PIVOT TABLE

[FIDO_FA]

Does anyone know a setting to display pivot tables as a % of sub total automatically within the Pivot Table Settings ?

 

[Andrew Poulsom]

I don't thik you can do it in Pivot Table Settings. You will need to add a field to your data.

 

[FIDO_FA]

Thanks I created a Formula to do the do in my Data sheet.

=H3/SUMIF($D$3:$D$438,$D3,H$3:H$438)

-Cheers