Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My in my case one Item assigned with OrderID may have quantity more than 1. For example one item with 2 quantity has been ordered
My fields are
1) date flag which have delivered and dispatched
2) Quantity
3) orderID
4) date field as logistic_date
however i am able to count order ID using flag and able to plot it on weekly basis.
kindly help me to figure out
How should I calculate sum of quantity with different flag like delivered and dispatched on weekly and daily basis?