% Difference from and Quarters

[massimop]

I need some help with a Pivot Table where I am comparing prices with previous quarters using the % Difference from and using Quarter/previous as the base.
The function works fine but I can't get any values on Q1 to compare with Q4 of the previous years. All Q1 for every years show no % difference.
any suggestions?

Thanks

[cbatrody]

Hi,

Can you please upload a sample template here?

[massimop]

Here's a sample...
I would like Qtr 1 in 2014 to be compared with Qtr4 in 2013 which has data and should be the previous.
Thanks!