I created a Dataset that has both PO's and SO's data but it only gives me detailed lines of the PO's….it won't show the SO's in detail lines (meaning the SO's only have 1 main line of data as one transaction). The PO's show every transaction line of the PO.
I would like to have the SO's also show every transaction line of each SO (detailed line items). How do I fix this dataset to display that info?
See photo below of my dataset.