How to calculate a percentage of two columns within a pivot table

Question

I have a pivot table where I have some columns that are calculated percentages (3rd column) of the previous two. The calculation works within the pivot table, but the grand total at the bottom does not (it's a sum total of the column). How can I alter the formula in grand total so that it takes 17,459/18,565 (like the data does within the pivot table)?

Answer 1

Hi,

Did you add the calculated field in PivotTable to create the percentage value?

Click the PivotTable- go to (Pivot Table Tools) Analyze- Fields, Items, & Sets- Calculated Field- Insert Calculated Field- enter the formula:

You can also refer to this support article:

https://www.got-it.ai/solutions/excel-chat/excel-tutorial/pivot-table/calculating-percentage-in-pivot-table

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.