| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a pivot table calculate the difference between two fields
My pivot table is summarized by group, then by Actual Headcount and Budget
Headcount. So for example, HR is the first category broken down into 10 heads of budget and 9 heads of actual. The Total line sums the Budget and Actual total to show 19. I would like the Total line to show the difference between Budget and Actuals. So instead of the sum of 19, I would like the pivot table to calculate the delta (Delta would equal 1: Budget of 10 - Actual of 9). I would like it to do this for each group (HR, Sales, etc.) Any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| repeating names in row fields of a pivot table | Excel Discussion (Misc queries) | |||
| Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
| Manipulating Pivot Table Data Fields | Charts and Charting in Excel | |||
| Change Data In Pivot Table | New Users to Excel | |||
| pivot table question, sum fields? | Excel Worksheet Functions | |||
Threaded Mode
