Forum Discussion
Comparing Data from two data sets/tables
I have two sets of data from two separate reports pulled into one excel file. I created pivots to summarize each of the amounts based on certain criteria and am trying to figure out the best way to s...
MF0160 It depends a bit on how complicated you want this to be and how neat the end result should look like. If both data sets are structured the same, you could just append them into one bigger data set and add a column indicating the source (i.e. report1 or report 2). Then you can create a pivot table on the combined data.
An alternative would be to "join" both reports via the Data Model (Power Pivot) and create a pivot table that way.
The attached file contains some examples of what you might want to try out for yourself. All are good enough to just spot the errors, so that you can correct them.