Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone!
I have 4 fields Working Center, Order, Order Start Date and Order End Date.
I want to sort my straight table in this order: Working Center A-Z, Order by min(StartDate).
I created custom sort expression , but it doesn't work.
See attachment
What have I done wrong?
This is the workink condition, let me know.
min(Aggr(NODISTINCT min(StartDate), WORKCENTER, ORDER))
Min expression doesn't exist in final chart, I created it just fot testing
In expression Sort ORDER
Aggr(Rank(-Min(StartDate),0,1),ORDER)
unfortunately does not work
I used that expression in your document, the one I attached, please tell me where the error is?
I tried your solution, but here begins distortion

For example here

agree?
This?

the same problem(((
It seems that problem causes orders that have both Working centers
I'm sorry Alex,
in this case, do You want Priority Order or Priority StartDate ?