Forum Discussion

Matt78's avatar
Matt78
Icon for Helper II rankHelper II
2 years ago

Data from another table filters out empty fields (should be visible)

Hello,   I have 2 data sources, other one is sales order list and other one is warehouse shipments with shipment numbers. What I would like to have is to get shipment numbers to my sales order list...
Need Help
Tips and Tricks
JoeBarry's avatar
JoeBarry
Icon for Solution Sage rankSolution Sage
2 years ago

Add to the Matrix, the No_ from Sales Order 1st (This is the shared dimension). Then add the columns you need from the Sales Line Items, then the Shipments.

Matt78's avatar
Matt78
Icon for Helper II rankHelper II
2 years ago

Relationships should be ok but it still gives error when I add shipments to the matrix