Apr 15 2020 06:27 PM
I'm trying to reconcile two nearly identical pivot tables. Normally I would use GETPIVOTDATA, subtract one from the other, drag the formula down and across the template, and do a find/replace for the necessary parameters. However, these are OLAP tables, so when I use GETPIVOTDATA it inserts these unique numbers for each row; I can't just use the normal function because I'd have to add one to the number for each line.
The only thing I can think of is Index/Match, which doesn't work well if the tables have to be refreshed. Any good ideas would be appreciated.