[header] How to calculate difference in pivot table [title] Launch microsoft excel. [title] Open the spreadsheet containing the pivot table and source data you are working with. [title] Select the worksheet tab containing the source data. 
[substeps] This may, or may not, be the same sheet where your pivot table is located. [title] Determine the calculation you would like to add.