Hi, all -
I have a table with two columns - budgeted salary and actual salary. We added a third column that based on the values of the other two columns has either an "Above" or an "At or Below" based on how actual salary compares to budgeted salary.
I want a pivot table to give a percentage of records being "at or below" the budgeted salary by level of position.
How does one do this in a pivot table?
I have attached an excel file with actual sample data.
Any ideas would be helpful.
Bookmarks