Thread: Help w/Pivot Table Calculated Fields

I am trying to create a calculated field in a pivot table named Total Food Sales that will subtract the Home and Misc. field from the Total field. I think I know on how to create the table, but I am not sure of what formula I need to use to do the subtraction of both (Home & Misc.) fields. Any help appreciated. I can't seem to locate the solution to that problem in the Office 2010, V2 Exploring manual. Thanks. pc

do you have a sample data/worksheet with you? I will try to help you
I am a bit familiar with calculated fields (basics at least)