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:

Pivot Table

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.

  • What if you add a column with that difference to the original table then include it in the pivot? – cybernetic.nomad Mar 2 '18 at 17:19
  • Please describe exactly what you tried (“I have tried playing with the OFFSET function” is too vague) and exactly what happened (“couldn’t get it to work” is too vague). – Scott Mar 2 '18 at 17:35
  • Upload the Sample Data (Original Data's few Rows), I'll provide a good solution to you using the Pivot Table. – Rajesh S Mar 3 '18 at 7:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.