Question: how to calculate growth in excel pivot table?
Answer: Select cell C4 on the sheet "Pivot Table"
Go to Pivot Table Tools > Options > Fields, Items and Sets > Calculate Item. ... 
In the Name box, type Growth.
In the Formula bar, enter =('2010' /'2009' )-1 and press OK.
Select the Growth column in the pivot table and press Ctrl+Shift+5 to convert the decimals to percentages.