Forum Discussion

mahenkj2's avatar
mahenkj2
Icon for Solution Sage rankSolution Sage
2 years ago

avoid filtering of date table when selected 'Items with no data'

I have a date table with one-to-many relathionwhip with Order table. Order table have one to many with Invoice table.   Not all the orders have invoices, so I would like to see orders with and with...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

mahenkj2 ,In such case it is better to have a Dimension/Master table for Invoice ID and join it back to you table and then use this option

mahenkj2's avatar
mahenkj2
Icon for Solution Sage rankSolution Sage
2 years ago

Hi amitchandak ,

 

Thanks. Do you mean creating a unique InvoiceID master and connect it to invoice table?

If so, that does not make any difference.