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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a pivot table calculate the difference between two fields
Hi
If Budget and Actual are Fields (columns in your source data), then from the PT Toolbar dropdown, select FormulasCalculated Field Set Name to Delta and Formula to =Actual-Budget You will now see an additional set of data for the difference. If Budget and Actual are different items in the same Field (same column) then from the PT dropdown choose FormulasCalculated Item and proceed as above -- Regards Roger Govier "tnlclifton" wrote in message ... 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? |
Reply |
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 |