Pivot table how to calculate column by grand total

[Kra]

Hi all! I have a pivot table in which I need to divide value from column B by grand total of column C. So yellow fields divide by red field. Results of manual calculation are in column H, but is it possible to do it directly in pivot table?

 

[RoryA]

Yes, but you'll have to use Power Pivot and the Data model so that you can use measures. You'd need to provide an idea of your source data layout ideally.

I'll move this to the relevant forum.