I have two different sets of data (2 worksheets in the same workbook) that I want to be combined into a single pivot table.
For the sake of this example, let's say that Country is the column that is in both sets of data.
How do I get the pivot table to show a sum of a column from each data set based on Country?
I am not familiar with Data Models or relationships.
See attachment.
Bookmarks