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

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.

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

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

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

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