Pivottables

[johnb]

Is it possible to use a pivottable to comapre 2 data
sources and produce a pivottable of variances? Is so How?

TIA
Johnb

 

[Dave Peterson]

This may work: I've copied|pasted one set of data under the other.

Then add an additional column to serve as an indicator (old or new).

Then created the pivottable with that indicator as a column field. Then I'd
usually convert to values and add a few formulas to look for differences. Apply
Data|filter|autofilter to find them.

Another option that may not work.

I've changed the values of the "new" data to negative
put -1 in an empty cell and copy it.
select the new (numeric only) data and edit|paste special and click multiply.

Then I could just look at the number and see differences.