This content has been marked as final. Show 2 replies
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)|
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|
Thanks in advance.