Pivot Table: How to create a Calculate Field that uses a "Difference From" column

Hi Everyone!

I am no stranger to VBulletin forums, but this is my first time on this message board. It is great to see such a huge community of helpful people!

It's 11PM, and I'm here at work with a problem that is boggling my mind. I am trying to create a calculated field in a PivotTable that refers to another column within the PivotTable that is a "Show Data As / Difference From / Prev / Year" value. My problem is that my new calculated field is not using the "Difference From" value, but rather the raw data value.

I have attached a spreadsheet that contains a simplified example of my problem. Please note that the "Sum of COL2" column uses the option "Show Data As / Difference From / Prev / Year". I would like the "Sum of TEST" calculated field to equal the sum of "Sum of COL1" and "Sum of COL2", where "Sum of COL2" is the "Show Data As / Difference From / Prev / Year" value rather than the raw data value. I think my problem is that the "Show data as" option *shows* the data as a difference, but does not actually treat the data as such when performing calculations on the field.

If anyone has any suggestions on how this can be done within the PivotTable, I would really appreciate it!

Thanks!

could you post a dummy workbook with the same set up?

Originally Posted by Everstrivin

could you post a dummy workbook with the same set up?

I have clarified my original question and added a simple example spreadsheet.

Thanks!

<<merged with initial post>>