Excel 2007 : Pivot Table - year on year growth rate for monthly data

Hi there,

This is my first post so I am keeping my fingers crossed!

I am trying to show Y/Y growth rate and I can only manage to do M/M by doing

1. Summerize value field by "Sum"
2. Show value as "% Difference From"
3. Base Filed "Month"
4. Base Item "(Previous)"

When I change Base Field from Month to Year then I got N/A.

Please help!

Thanks!

can you post the spreadsheet again?