Minimum value through out a 12w period of time
Hi! Hope that you all are doing fine with this crisis!
I have a line item that, for each reference, calculates the balance between need and stock for each week.
I would like to create another line item, without the time dimension, that gives me the worst situation in the next 12 wks for each reference and (another line item) at which week this is going to happen.
- for the first reference, it would be -2322 pcs, at wk 5/10/20 (or in 7wks)
- for the 2nd reference, it would be -133 pcs, at wk 26/10/20 (or in 10 wks)
I already tried with rank and min functions but I couldn't find the right solution. Can anybody help me, please? 🙂
Thank you very much!!