Hello all,

I have a pivot table where the Row Label is the Product, Column Labels are dates grouped by Month and Year and the Values is the revenue. Each row in my source table is a separate transaction/sale. It contains all entries for 2014 and through January 2015. In my pivot table I have filtered out Feb. 2014 through Dec. 2014 so that I am only seeing January 2014 and January 2015. I am trying to create a calculated field that will show me the % Difference of revenue between January 2014 and January 2015. I get an error stating I can't do this because the Date field is grouped. Is there are way to accomplish this in the pivot table? Also, as the year goes along I will be adjusting the filter on the pivot table to only show the revenue for the previous month and the same month the previous year.

Thanks in advance for your help.