Forum Discussion
Help With Pivot tables. I have a list of popular part numbers and a list of cust part nos.
Hello I have a list of part numbers that are most popular in the state. I also have a list of which part numbers this customer has in stock. I want to see which of his part numbers are in the list...
Hi Spikekahl
in order to analyze two different source tables with one Pivottable, you have several options:
1. Merge/copy the two tables manually to a single one
2. Merge the two tables with a join in Power Query (this is what I would recommend)
3. Load the two tables in the datamodel and create a relationshipt between them. Depending on the source data, this might require some additional preparation.
Then you can create your Pivottable and analyze the data.