Hello,
I have a file that holds all of the salaries and bonuses per year for our employees. Management would like to see the % salary change every year as well as the bonus as a % of salary for each year.
However, I do not know how or even if this will work since you cannot (as far as I know) add calculated fields based on values within a row (Pay Category) in a Pivot Table.
I would do just a nicely formatted table (no Pivot) but they want to be able to filter by manager (and subordinates)
I attached an example file.
Numbers.png
Bookmarks