Help With Pivot tables. I have a list of popular part numbers and a list of cust part nos.

Question

Hello I have a list of part numbers that are most popular in the state.&nbsp; &nbsp;I also have a list of which part numbers this customer has in stock.&nbsp; I want to see which of his part numbers are in the list of popular ones by rank. Also, how many he has in stock of each.&nbsp; ex:Most popular in State-PART NUMBER&nbsp; &nbsp; &nbsp; &nbsp;RANK&nbsp; &nbsp; &nbsp;IN STOCK PAIRSBS123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1BS1467&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2BR4557&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3BS199&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4The customer has:PART NUMBER&nbsp; &nbsp; &nbsp; RANK&nbsp; &nbsp;IN STOCK PAIRSBR457&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2BS123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3BS188&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Thanks for your help!&nbsp; Mike Kahl&nbsp;

martin_weiss · Answer

Hi&nbsp;Spikekahl&nbsp;&nbsp;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 one2. 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.&nbsp;&nbsp;&nbsp;Then you can create your Pivottable and analyze the data.

Forum Discussion

Help With Pivot tables. I have a list of popular part numbers and a list of cust part nos.

1 Reply

Resources