Here is my Pivot Table dilema:
Fields:
"Employee" "Total Vacation" "Vac Reported" Caculates = "Remain Vac"
This part works at this level as I add item formula: Total Vacation - Vac
Reported
However, when I add a location to the line, the formula returns a result for
each employee for each location instead of that employees location.