Calculate year over year growth rates and ratios using Pivot Table

Pivot tables can be used to summarize information in a large set of tables. But besides aggregating, you can also calculate ratios, year-over-year growth rates, and many more using Pivot Tables.

In this video, you will learn how to calculate growth rates over a fixed base year or previous year. In addition to year-over-year growth, you can also calculate month-on-month growth or quarter-over-quarter growth.

You will also learn how to calculate and show data as a proportion of column total and grand total.

[salmakhaled]

Thanks a lot, very helpful!! Short, simple and to the point

[Inanothertimeandspace]

Whatttt! This is so simple and awesome. Why does it not have a million views? I’ve been looking for this answer for over an hour, and all of the “solves” were super complicated.

[JenkinsJordan]

At 2:17, this isn't calculating year over year growth - it's just month-over-month (e.g. C15 is just Feb'19 vs Jan'19). Do you have to reorganize your pivot table monthly arrangement to make this year-over-year or is there a smarter way to get the calc?