software

Here is my Pivot Table dilema:
Fields:
quot;Employeequot; quot;Total Vacationquot; quot;Vac Reportedquot; Caculates = quot;Remain Vacquot;
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.


is there some reason that you can't do the calculation on the worksheet
instead of as a calculated field?--
steven1001
------------------------------------------------------------------------
steven1001's Profile: www.excelforum.com/member.php...oamp;userid=30757
View this thread: www.excelforum.com/showthread...hreadid=536984This 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.

quot;steven1001quot; wrote:

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