Cannot get Linking to work

Im trying to sum specific vendor purchases by specific customers in a specific date range.
Im trying to link the sales invoice line table which can filter the sell-to customer no. and posting date. It has the common link of item number (No.) to link to the Item table which contains the specific Vendor No.
I cant get the correct formula(s) to get these sums. Ive tried creating tables to provide the document number and subtotal of that document, I cant however create a formula to pull the specific item numbers from that document that relate only to a specific vendor.


Please sign in to leave a comment.