How do I set up a formula using same field in pivot table?

K

Kevin @ P3

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.
 
S

steven1001

is there some reason that you can't do the calculation on the workshee
instead of as a calculated field
 
K

Kevin @ P3

This is a recurring report and needs to be flexible enough to allow dept.
managers to look at only thier data. The formatting etc. gets lost once you
start selecting my location.
 
Top