Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Quarter on Quarter % Change Pivot Table

Hi, I have the following data and I would like to create a pivot table to show the q-o-q percentage change for each item.

What is the expression formula for it? Appreciate the help!

   

YearQtrApartmentCondominium
2014-Q418,51914,102
2015-Q114,67213,851
2015-Q215,08613,823
2015-Q312,20813,568
2015-Q414,51813,808
2016-Q116,08413,510
2016-Q214,71815,097
2016-Q314,62714,396
2016-Q414,68814,199
2017-Q115,79514,401
2017-Q216,15214,714
2017-Q315,83414,947
2017-Q416,36515,783
0 Replies