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
Matt78's avatar
Matt78
Icon for Helper II rankHelper II
2 years ago

I did that but for some reason when I add Shipments in the matrox it gives error it cannot determine relationships between the fields.

 

 

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