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>
