Two Data Source Pivot Returning Field Total Sum Instead of Individual Values

[ohnow]

Hello,
I'm trying to create a pivot using two data sources for the first time. I'm familiar with one-source pivots. In the same workbook, I have two worksheets which have inventory quantities by inventory part number. I am trying to make a comparison of the two. I followed the steps from YouTube vid: Advanced PivotTables: Combining Data from Multiple Sheets.

Both sheets use the column name Full_Comp_Part for the part number and and Beg_On_Hand for the quantity. Both sheets use the same part numbers. The sheet called "Inv Flow by Mo" has vlookups to the sheet called "Beginning Inv". In the pivot, the quantities from the Beginning inventory sheet show correctly by inventory part number. But, the quantities from the Inv Flow by Mo sheet are the same for every part number and are the total of all part number quantities summed together. I'm new to BI and I tried to compare these two sheets in BI and saw the same results.

Does anyone know how to show individual quantities by part number from the Inv Flow by Mo sheet in the pivot?

Here is an example of the pivot:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Values[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Full_Comp_Part[/TD]
[TD]Status[/TD]
[TD]Sum of Beg_On_Hand[/TD]
[TD]Sum of Beg_On_Hand[/TD]
[/TR]
[TR]
[TD]A1234[/TD]
[TD]New[/TD]
[TD]82[/TD]
[TD]800120[/TD]
[/TR]
[TR]
[TD]B1234[/TD]
[TD]Old[/TD]
[TD]121[/TD]
[TD]800120[/TD]
[/TR]
[TR]
[TD]C1234[/TD]
[TD]New[/TD]
[TD]536[/TD]
[TD]800120[/TD]
[/TR]
</tbody>[/TABLE]

 

[ohnow]

Hello,
In my original post, my pivot was using the Full_Comp_Part and Status from the Beginning Inv sheet. I just tried using the Inv Flow by Mo sheet instead and was able to get the individual quantities by item like I wanted. I didn't know it would make a difference which table is used?

Also, when I add Status to the new pivot, every available status is listed for every part, even though the part only has one status. I have seen this behavior before and could never figure out why this happens?

 

[ohnow]

Just want to bump this question