Creating a column in Pivot Table as a % of another column in PT that is count of value field.

Danny Hsu 0 Reputation points
2023-04-14T14:49:05.6266667+00:00

I have a pivot table below with lots of sum values columns. The column I'm hoping to calculate is in Column C. I want to show this as a % of the item in Column D. Essentially, it should be showing 35%, 62%, 76% etc. Both Column C and D is using the "summarize value by 'count'" However, for the life of me, I can't figure out how to set this up, can someone please help me? User's image

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,540 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 22,471 Reputation points Microsoft Vendor
    2023-04-17T09:21:47.5433333+00:00

    Hi, You can create a custom field, Under PivotTable Analyze tab- Fields, Items, & Set- Calculated Field...:

    User's image

    Try this method and check the result.


    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