Excel - Calculate Differences in a Pivot Table

In this short video you'll learn how to calculate the difference between 2 values, for example "what is the difference in both revenue and percentage terms between Jan and Feb, Feb and Mar, Mar and Apr etc?

Connect with me via:

[zlee]

Exactly what I was looking for. Thank you

[oldirtydasher]

Thanks for this! I love creating pivot tables; however doing calculations within them is confusing.

[garys]

Thanks Mike, that was interesting. I've done a lot of work recently on pivot tables, but probably wouldn't have thought to repeat the same data multiple times to get different formats.

[gilaniali]

@Mike How do you get Jan to subtract from May instead of showing Blank?