Share via

Pivot Table %

Anonymous
2025-01-30T18:43:37+00:00

I am trying to use a pivot table to show % compliant (% of "Yes") per Nurse. I've tried various options and nothing works. I can manually get percentages with calculations. Any help appreciated.

Microsoft 365 and Office | Excel | For business | Windows

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2025-01-30T20:58:32+00:00

    Here is a screenshot of the PivotTable Fields pane:

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2025-01-30T20:51:20+00:00

    Thank you! I am using a work computer and it has the link blocked. I will try to open it on personal computer later.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. HansV 462.6K Reputation points
    2025-01-30T20:23:33+00:00

    See the workbook on Dropbox: PivotPercent.xlsx

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. HansV 462.6K Reputation points
    2025-01-30T19:51:34+00:00

    Add Compliant to the Columns area.

    Click on Compliant in the Values area and select Value Field Settings from the drop-down menu.

    Activate the Show Values As tab.

    Select '% of Row Total' from the drop-down.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2025-01-30T20:00:28+00:00

    Do you mind showing me what your PivotTable Fields look like?

    Was this answer helpful?

    0 comments