Pivot tables: how do you make a grand total in a pivot table to show percentage growth % or % evolution instead of tallying or adding the percentages as a total?

Question

Pivot tables: how do you make a grand total in a pivot table to show percentage growth % or % evolution instead of tallying or adding the percentages as a total?

Anonymous

Pivot tables: how do you make a grand total in a pivot table to show percentage growth % or % evolution instead of tallying or adding the percentages as a total?

The grand total of my excel table percentage growth is appearing as a value. This value is the sum of the above column. Naturally it does not make business sense to want to report on this.

Out of desperation, when I attempt to input the formula manually it does not allow and serves me the error message of: we can't change this part of the Pivottable.

I do not want to manually enter it, I need it to be automated.

The above percentage growths are calculated by means of: clicking on cell G3 > Pivottable Analyze > Calculate Item > creating new formula named "Evol %", then creating =IFERROR(('2023'/'2022'-1),"")

This however does not work on the Grand Total Column.

Please help?

Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20806) 64-bit

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

Greetings! I am Ajibola, eager to assist you with confidence and assertiveness. I guarantee to provide you with exceptional support.

One way is to use a calculated field to create a new measure that calculates the percentage growth or evolution based on the original values. You can do this by clicking on the PivotTable Analyze tab, then clicking on Fields, Items & Sets > Calculated Field. In the Insert Calculated Field dialogue box, you can enter a name for the new field, such as "Growth %", and then enter a formula that calculates the percentage growth or evolution, such as =IFERROR(('2023'-'2022')/'2022',""). Then click Add and OK. You can then drag the new field to the Values area of the pivot table and change its format to percentage

'Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.'

https://www.myexcelonline.com/blog/show-percent-grand-total-excel-pivot-tables/

If you have any further questions or need additional assistance, please feel free to ask. I'm here to help!

Give back to the Community. Help the next person with this issue by indicating if this reply solved your problem. Click Yes or No below.

Kind regards.

Ajibola.

Answer 2

Ashish Mathur 101.8K Volunteer Moderator

Hi,

Share some data to work with and show the expected result.

0 comments

Share via

Pivot tables: how do you make a grand total in a pivot table to show percentage growth % or % evolution instead of tallying or adding the percentages as a total?

2 answers