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
PO# | PO_Amt | Invoice Amt | Ledger Amt |
B001 | |||
1234 | 10,509.60 | 10,509.60 | 10,575.99 |
B002 | |||
blank | 817.64 | 0 | 0 |
B003 | |||
5678 | 6,133.5 | 6,378.84 | 6,378.84 |
<tbody>
</tbody>