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

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

[steven1001]

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

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

"steven1001" wrote:

>
> is there some reason that you can't do the calculation on the worksheet
> instead of as a calculated field?
>
>
> --
> steven1001
> ------------------------------------------------------------------------
> steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
> View this thread: http://www.excelforum.com/showthread...hreadid=536984
>
>