Assume a three column dataset which has Year, Company ID and Cash flows. For each Company, there are cash flows for multiple years. So for Company ID A001, there are 7 rows, one each for 2010 to 2004 and cash flows appearing in a third column. Let’s assume the number of rows are 750,000.
The task is to compute the year on year growth rate in a fourth column. While this problem can easily be solved by writing a formula in a fourth column, copying that formula all the way down to 750,000 rows will be time consuming and processor intensive.
I have been able to solve this problem using PowerPivot. You may download the workbook from here.
You may refer to related questions at this link
1. Computing growth % inside a pivot table
2. Compute Pro rata growth rate within a Pivot Table
Compute year on year growth in a Pivot Table
{ 0 Comments }