Hi Everyone , i have in my data model the following tables:
- Sales order table
- Inventory Table
I created a chart with informatino about Order Number and item number. I would like to see in the same chart, the quantity on stock about an item (Coming from table Inventory). How this can be done?
I would like not to left-join, since i would like to have a varibale with a date, to be able to filter the quantity on stock based on the expiration date. So if i set varibale as 10/03/2022, the quantity that should appear on chart should it be related just for items expiring after that date.
What's the best solution to meet this requirement?
Thank you!