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

Wraspir, Kristi 0 Reputation points
2024-01-05T19:35:19.32+00:00

User's image

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)?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,165 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 27,871 Reputation points Microsoft Vendor
    2024-01-08T07:35:15.4433333+00:00

    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:

    User's image

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.