<p><span style="font-family:'courier new', courier, monospace;">Hello,</span></p>
<p> </p>
<p>could anyone please help me to achieve this requirement...</p>
<p> </p>
<p><span style="font-family:'courier new', courier, monospace;"><strong>Dataset</strong>:<br>
product_name, product_type_id, Serial_Number, Col1, Col2......<br><br><strong>Sample Data</strong>:<br>
product_name product_type_id Serial_Number Col1 Col2......<br>
name_1 1 1 val val<br>
name_1 1 2 val val<br>
name_1 1 3 val val<br>
name_1 1 4 val val<br>
name_1 1 5 val val<br><br>
name_2 2 1 val val<br>
name_2 2 2 val val<br>
name_2 2 3 val val<br>
name_2 2 4 val val<br><br>
name_3 1 1 val val<br>
name_3 1 2 val val<br><br>
name_4 3 1 val val<br>
name_4 3 2 val val<br>
name_4 3 3 val val<br>
......<br><br><strong>Table Group: </strong>on product_name<br><br><strong>sort:</strong> on Serial_Number,<br>
if product_type_id is 1 or 2, sort by Serial_Number accessing<br>
if product_type_id is 3 or 4 or 5, sort by Serial_Number descending<br><br><strong>The output should look like</strong>:<br>
name_1<br>
Serial_Number Col1 Col2......<br>
1 val val<br>
2 val val<br>
3 val val<br>
4 val val<br>
5 val val<br><br>
name_2<br>
Serial_Number Col1 Col2......<br>
4 val val<br>
3 val val<br>
2 val val<br>
1 val val<br><br>
name_3<br>
Serial_Number Col1 Col2......<br>
1 val val<br>
2 val val<br><br>
name_4<br>
Serial_Number Col1 Col2......<br>
1 val val<br>
2 val val<br>
3 val val</span><br>
</p>
<p>Thanks in advance!!!</p>
<p> </p>
