Hello Everyone,
I've searched long and hard for an answer to the following problem (no luck yet):
I want to add two columns to a Pivot table that does some summarization to a status field.
Below are two screen shots of both the Pivot Table and the data that is referenced.
Data:
Link to image of data
Pivot:
Link to image of Pivot Table
What I really need is to add to the pivot table two percentages:
1) Percentage of Approved (Approved / Grand Total for manager) Example: for Ann that would be 2 divided by 3 for a Percentage Approved of 67%.
2) Percentage of Assessed (Assessed / Grand Total for manager) Example:
for Ann, Assessed is 0 so Percentage Assessed is 0%
Attached is a spreadsheet with the above pivot table and data.
Any help would be greatly appreciated!
Bookmarks