Related tables limited data

[ChuckS]

Hello All,

I am hitting a wall on what should be a simple task.
I have two tables called "Orders" and "Rejected Orders" with a relationship between the Order_Number field that is in both.

When I add field from the order table to a table visual all the orders and there assocciated data is displayed.

Hoever if I add a field from the related "Rejected Orders" table, such as who rejected it, the resalts in the visual are only orders that have been rejected.

The goal is to show all orders and if there is a rejected order to show its values in otherwise it should be blank.

I have tested with changing the cross-filter but that did not seem to help.

What am I missing?

Thanks

Chuck

[vojtechsima · Accepted solution]

Hi, @ChuckS ,
Let's say you have this setup:

If the lower table, click on the Order_Number and click show items with No Data:

[ChuckS]

OMG it the forum has an idiot of the day award I nominate myself. 

Thank you, that solved my issue.

[vojtechsima]

@ChuckS 
No worries, man.