field setting help in pivot tables

**aravindhan_31** · 10-09-2009, 05:43 AM

Hi,

I have a pivot table with Sales and Budget, if i need to find the difference in pivot table i think i need to use field settings, however i am not getting the result

I have attached the same file for reference

thanks for help

Arvind

**NBVC** · 10-09-2009, 07:59 AM

Ensure your PivotTable toolbar is available... View|Toolbars|PivotTable

then while in your pivot table got the PivotTable dropdown in the toolbar.. and select Formulas and select Calculated Field

In the Name field enter a name, like Difference

Then in the Formula field, remove the 0 (and leave the = sign)...

Select Budget_Sales_YTD from the Fields list and click Insert Field and enter a minus (-) sign, then select Sales_Value from the Fields list and click Insert Field

Click Ok.

**aravindhan_31** · 10-14-2009, 09:46 AM

Hi,
Thanks for your help.. it works for me..

what if I want to modify the fields which are calculated already. in this case:
field Difference?

Thanks for your help
Arvind

**NBVC** · 10-14-2009, 09:55 AM

Not sure what you mean? Please elaborate.

**aravindhan_31** · 10-15-2009, 02:15 PM

Hi,

what I meant is . I have added a field called 'Difference' with the formula as
Budget_Sales_YTD - Sales_value. Is it possible to modify the formula?
say instead of - i may put +.. I dont find option to modify the formula..

hope its clear
thanks for ur help

**NBVC** · 10-15-2009, 02:24 PM

From the PT toolbar, select Formulas and then Calculated Fields...

Select the Diff formula from the drop down Name field..

Change the - to a + and click Modify.

Click Ok to apply