Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We need to know the structure of your data. If there is no link between Orders and Deliveries (unlikely), then you can have a simple MasterCalendar and filter with that.
If your data has a link between Orders and Deliveries, then I guess you would have to concatenate the tables, and the then use the relevant date to link to your master calendar.
Personally, I've never been able to solve this problem elegantly, because there isn't a reason to assume that the Order-Delivery link is 1:1.
Order_Delivery_Table:
Load 'Order' as Flag,
Order Date as "Common Date"
Resident Order Table;
Concatenate (Order_Delivery_Table)
Load 'Delivery' as Flag,
Delivery Date as "Common Table"
Resident Delivery Table;
Use the Common Date Field as a filter where you can find Order and Delivery details with respect to date.
Please share your data or app.
Thanks.
May be this, if your data fields are of date type -
Sum({<OrderDate={">=$(=MakeDate(2018,02,01))"},DeliveryDate={">=$(=MakeDate(2018,02,01))"}>}Value)