Pivot table percentage calculations

How can I calculate percentage values in the grand total, in a pivot table as shown in the image attached (From an excel)?

image

Sweta,

In order to do this, you need to create that calculation in the worksheet. You would create a level for the Region, then calculate the percentages as a formula at that level.

Hope this helps.

1 Like