I recently created a PivotTable and I'm trying to create a column to calculate percentage growth for each industry by year and month.

I prefer to not manually enter in these formulas and automate this process so I can enter in more data each month and click "Refresh" on the Pivot Table.

Here is a basic example of what I'm looking at:

|Industry|Month|Year|Sales
GOVT | 4 | 2005 | 5555
GOVT | 5 | 2005 | 6219
GOVT | 6 | 2005 | 1234
GOVT | 7 | 2005 | 1800

I would like to add a % Increase Column or Row if possible.

Any suggestions?

Thanks,

Elise