Calculate two dates changes in Pivot table

[msmichael]

Hi experts,

I have a pivot table with two dimensions (histDate, Group) and two expressions (Value1, Value2).

In the histDate dimension, right now I have two dates - 11/29/2018 and 11/30/2018.

The pivot table is now showing 11/29 and 11/30 data for Value1 and Value2,

now I want to keep 11/30 column, change the 11/29 column to the two days' difference, something like below screenshot:

How can I do it?

qvw file is attached.

Thanks!

[hopkinsc]

Hi,

I am unsure what you are trying to do. 

Could you attach an excel file with your desired output please?

[msmichael]

OK. Pls see attached Excel sheet.

Basically, right now in my pivot table, I have both 11/29 column and 11/30 column for Value1 field and Value2 field.

I want to change the 11/29 columns so that the differences of the values between the two days show in this column..