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 Actual. 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.
Bookmarks