Could someone help me with a pivot table issue? I am having difficulties combining 3 tables together. I created a one to many relationship from table 1 to table 2 and table 3 as shown by the arrows in the below image. However, when I add a pivot table, all of the invoice numbers are showing up under every purchase order number.
I tried the auto-detect in case I was missing something and 0 results came up.
I would like the pivot table to show something like this
[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD]PO#[/TD]
[TD]PO_Amt[/TD]
[TD]Invoice Amt[/TD]
[TD]Ledger Amt[/TD]
[/TR]
[TR]
[TD]B001[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 1234[/TD]
[TD]10,509.60[/TD]
[TD]10,509.60[/TD]
[TD]10,575.99[/TD]
[/TR]
[TR]
[TD]B002[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] blank[/TD]
[TD]817.64[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]B003[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 5678[/TD]
[TD]6,133.5[/TD]
[TD]6,378.84[/TD]
[TD]6,378.84[/TD]
[/TR]
</tbody>[/TABLE]
