Hopefully someone can help or point me in the right direction for this as its driving me crazy! I have a Pivot Table made up from another table that contains a bunch of numbers for different categories. My Pivot table gives me the totals for those categories and displays by Person Name then the date – see image:
That all works perfectly for what we need but I need to add two more columns that calculates the difference between the latest entry and the previous entry - so for example the 4th column would show 0Cool00's RSS 2/22/2018 Total - 2/27/2018 Total, then the 5th column would do the same for the Gold total, then in 5 days time when we add the new numbers for 3/4/2018 the pattern continues, take the previous away from the latest giving the actual total for that date... this is where I'm not sure what the formula would be.
I have tried playing with the OFFSET function but couldn't get it to work. I realize I can add two manual columns to the end and use a regular formula but I'd like it to be contained within the Pivot Table so it updates automatically.
Hopefully that makes sense! Any insight will be appreciated.