Hi there,

I have a worksheet with click data by campaign and date. Example:
Please Login or Register  to view this content.
Based on this I have have created a pivot table that groups the data by coutnry and focuses on a single month:
Month filter set to Feb 2015
Please Login or Register  to view this content.
Now I would like to add a column that shows the difference to the previous month. Example:
Please Login or Register  to view this content.
I tried the pivot calculation '% difference from' using either 'previous' or explicitly selecting Jan 2015, but the resulting column shows always zero. The only way I can get data with '% difference from' is if I add the column 'date' to the section 'column labels of the pivot table and change the filter to include both dates. But this adds extra columns for the previous week into the table - I do not want this.

Is there any way to do that with a pivot table?

I have considered not using a pivot table and instead use sumifs to calculate the totals. But unfortunately the list of countries in the report changes fairly often and I could not find a way to automatically display new countries in the report when using sumifs.


Thank you for any tips/workarounds/ideas/... - at the moment I am quite stuck

Claudia