Compare Pivot Tables

salimthaj · Aug 8th 2007

Hi,

Is it possible for me to compare two pivot tables and get a report. in the attached example, is it possible to compare sheet1 and sheet 2, if the values haven't changed, then it should be green, or it should be red. Could somebody help me with this please.

Dave Hawley · Aug 9th 2007

Re: Compare Two Pivot Tables

No PivotTable in your sample. Use Conditional Formatting and GETPIVOTDATA

salimthaj · Aug 9th 2007

Re: Compare Pivot Tables

Hi Dave,

Thanks for the response, I made a pivot and copy pasted the values, since the file size was big.Is it possible to compare it.

**norie** · Aug 9th 2007

Re: Compare Pivot Tables

salim

How do you want to compare them?

Personally I would just copy one of them, paste special and use the subtract operation.

When I do that with your sample data everything goes to 0 on the pivot table pasted too.

By the way would it not be easier to do the comparison using the raw data?

Compare Pivot Tables

Participate now!

Share