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. How do I set up the pivot table so that only the corresponding invoice number shows up under the purchase order, and blank if there is no corresponding invoice.
I tried the auto-detect in case I was missing something and 0 results came up.