Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I am trying hard to figure out a way for this. Kindly help.
I have the following table after doing some work on the base data.
Place | Warehouse | Source | Freight1 | Freight2 | Sum (Freight1, Freight2) |
P1 | WH1 | S1 | 100 | 10 | 110 |
P1 | WH1 | S2 | 200 | 20 | 220 |
P1 | WH2 | S1 | 200 | 10 | 210 |
P2 | WH2 | S1 | 300 | 20 | 320 |
P2 | WH2 | S2 | 400 | 10 | 410 |
I want to add one column "Classification", which would give
"L1" if the Sum column for a given Place is the MINIMUM among the available options.
"L2" if the Sum column for a given Place is the 2nd MINIMUM and so on.
I have showed the example for 2 Places.
Something like this.
Place | Warehouse | Source | Freight1 | Freight2 | Sum (Freight1, Freight2) | Classification |
P1 | WH1 | S1 | 100 | 10 | 110 | L1 |
P1 | WH1 | S2 | 200 | 20 | 220 | L3 |
P1 | WH2 | S1 | 200 | 10 | 210 | L2 |
P2 | WH2 | S1 | 300 | 20 | 320 | L1 |
P2 | WH2 | S2 | 400 | 10 | 410 | L2 |
Thanks in advance.
See attached qvw.
Thanks a lot Gysbert.
Just wanted to check if there is any way this could be done in the script.
Would be very helpful if a separate listbox could be made.
Thanks again