Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply a formula as a pivot table calc or suggestion | Excel Worksheet Functions | |||
Pivot table formula | Excel Worksheet Functions | |||
% of calculated field in pivot table | Excel Worksheet Functions | |||
Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
Pivot table page field switch to (all) if my criteria is not avail | Excel Discussion (Misc queries) |