Hi to all,

I'm quite new to pivot table and i trying to create a custom difference column for daily sales. Was wondering can anyone guide me along. Tried calculated field and calculated item but not sure how should i add in for the formula.

1.jpg

As you can see from the image, I would like to add in the difference column at the E column showing the total difference example dated 30/11/17 to the latest date loaded from my data. And the difference value can also be change according to the date I would like to compare example 30/11/17 and 1/12/17.

is this possible for pivot table?
Appreciate any help!