Sorting the data based on due date and product

[NakulMalisetty]

Hi Everyone,

I need some help on the sorting, the sorting should be done on 'due date' then grouped by 'Product' for each row. The data with lesser due days is 2 so, it should be the first record however, instead of picking 'due date' 3 as the next record, it should group the 'Product' for the first record then it should go to next 'due date' and do the same.

Below tables show the input and expected output. Any suggestions would be appreciated.

INPUT					OUTPUT
Online	A	10			Order Type	Product	Due Days
Offline	A	3			Offline	C	2
Third party	A	11			Third party	C	4
Online	B	4			Online	C	8
Offline	B	5			Offline	A	3
Third party	B	6			Online	A	10
Online	C	8			Third party	A	11
Offline	C	2			Online	B	4
Third party	C	4			Offline	B	5
					Third party	B	6

Thanks

Nakul

[alexnajm]

Have you tried my solution on your data? I have tried multiple times and it still works.

if it doesn’t for you, provide a concrete example of it not working and a working input and output data result

[NakulMalisetty]

Thank you Alex!