Pivot table wont find the difference correctly

**breazzyyy** · 10-22-2015, 05:59 PM

Good afternoon all,

I have a pivot table pulling information from raw data. The raw data has many columns with a column that shows the fiscal year (2014, 2015) from the first column (which are just dates).

In my pivot table, for the column labels I have the quarter and the fiscal year with values in the table. I can get a subtotal for 2014 and 2015, but is there a way I can find the difference in value for (2015- 2014)?

Because the fiscal year is one column in the raw data, it doesn't seem to allow me to calculate that field.

Thank you!

**tuph** · 10-23-2015, 12:52 AM

Please attach your workbook so we can work on solutions using your actual data. Remember to remove/replace any sensitive info before uploading the file.