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!
YearQtr | Apartment | Condominium |
2014-Q4 | 18,519 | 14,102 |
2015-Q1 | 14,672 | 13,851 |
2015-Q2 | 15,086 | 13,823 |
2015-Q3 | 12,208 | 13,568 |
2015-Q4 | 14,518 | 13,808 |
2016-Q1 | 16,084 | 13,510 |
2016-Q2 | 14,718 | 15,097 |
2016-Q3 | 14,627 | 14,396 |
2016-Q4 | 14,688 | 14,199 |
2017-Q1 | 15,795 | 14,401 |
2017-Q2 | 16,152 | 14,714 |
2017-Q3 | 15,834 | 14,947 |
2017-Q4 | 16,365 | 15,783 |