Pivot table with two sources

[Assamita]

Hi,
I'm struggling to create a pivot table, I thought you might be able to help.
I have a list of sales order in a certain period of time. Among other information, it has the country, date and vendor.
Then I have another list with all the returns, again by country, vendor and date.

My goal is to have a pivot table with all the countries in the rows, then the vendors also in the rows, as the 2nd tier, and then column values, one column for the sum of sales orders, and another for the sum of returns. Then the date could be set up as a filter or whatever. That way I could create a percentage graph, with the number of returns against the total of sales orders.

I can't figure out how to do it. Any ideas?

Thank you

 

[Johnny C]

I think that to do this you need to create a data model. A data model lets you create a pivot table with multiple sources of data. IIRC you create a pivot table, then add to the data model, then add the second pivot table to the data model and create the relationships between the two.

 

[Assamita]

Thank you Johnny C, but I think that requires an Add-in (Power Pivot) and I don't have it. I'm using 2010.
It's probably something that can be done with a macro, but I'm looking if there's an easier solution first.

 

[dhunton]

I have a similar problem: I have a sheet with customer's support phone calls, and a sheet with customer's orders. I need to have pivot charts for both (calls on one chart, orders on the other) linked to the same slicer (customer name), so I think that means they need to be on the same pivot table.

(If my question needs to be a separate discussion, I'd be happy to do that.)