topic Sorting Issue: in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457102#M1929474 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In&nbsp; my internal am having the below values..</P><P></P><P></P><P><STRONG>Year/Month&nbsp;&nbsp;&nbsp; Emp Type&nbsp;&nbsp;&nbsp; Salary struct&nbsp;&nbsp;&nbsp; Gross.</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG style="font-size: 13.3333px;">2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P></P><P><STRONG style="font-size: 13.3333px;">May-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Direct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P></P><P><STRONG style="font-size: 13.3333px;">Aug-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Direct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Aug-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></STRONG></P><P><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P>I want the sorting in only one column E<STRONG>mp Type (ascending)</STRONG> remaining columns are same....if i change emp type means year and month</P><P>column also changing. . .</P><P></P><P>The correct order i want is..</P><P></P><P style="font-size: 13.3333px;"><STRONG>Year/Month&nbsp;&nbsp;&nbsp; Emp Type&nbsp;&nbsp;&nbsp; Salary struct&nbsp;&nbsp;&nbsp; Gross.</STRONG></P><P style="font-size: 13.3333px;"><STRONG><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG>2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P style="font-size: 13.3333px;"><STRONG><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">May-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Direct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Aug-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">Base&nbsp; </SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Aug-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">Direct</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00..</STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Anyone suggest please how to do this??</STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Regards,</STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Nithya<BR /></STRONG></STRONG></STRONG></P></BODY></HTML> Tue, 09 Feb 2016 05:55:00 GMT former_member225134 2016-02-09T05:55:00Z Sorting Issue: https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457102#M1929474 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In&nbsp; my internal am having the below values..</P><P></P><P></P><P><STRONG>Year/Month&nbsp;&nbsp;&nbsp; Emp Type&nbsp;&nbsp;&nbsp; Salary struct&nbsp;&nbsp;&nbsp; Gross.</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG style="font-size: 13.3333px;">2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P></P><P><STRONG style="font-size: 13.3333px;">May-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Direct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P></P><P><STRONG style="font-size: 13.3333px;">Aug-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Direct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Aug-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></STRONG></P><P><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P>I want the sorting in only one column E<STRONG>mp Type (ascending)</STRONG> remaining columns are same....if i change emp type means year and month</P><P>column also changing. . .</P><P></P><P>The correct order i want is..</P><P></P><P style="font-size: 13.3333px;"><STRONG>Year/Month&nbsp;&nbsp;&nbsp; Emp Type&nbsp;&nbsp;&nbsp; Salary struct&nbsp;&nbsp;&nbsp; Gross.</STRONG></P><P style="font-size: 13.3333px;"><STRONG><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG>2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P style="font-size: 13.3333px;"><STRONG><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">May-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Direct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Aug-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">Base&nbsp; </SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00</STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Aug-15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">Direct</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gross&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.00..</STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Anyone suggest please how to do this??</STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><BR /></STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Regards,</STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Nithya<BR /></STRONG></STRONG></STRONG></P></BODY></HTML> Tue, 09 Feb 2016 05:55:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457102#M1929474 former_member225134 2016-02-09T05:55:00Z Re: Sorting Issue: https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457103#M1929475 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Convert year/month to the below value. </P><P>2014</P><P>2015</P><P>2015-05</P><P>2015-07</P><P>2015-07</P><P></P><P>Now sort internal table by column 1 column 2.</P><P></P><P>Regards,</P><P>Naveen Kumar. </P></BODY></HTML> Tue, 09 Feb 2016 06:11:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457103#M1929475 Former Member 2016-02-09T06:11:49Z Re: Sorting Issue: https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457104#M1929476 <HTML><HEAD></HEAD><BODY><P>Hi Naveen,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thanks for your repli,but the user wants the month format only.(may ,aug like that)</P><P></P><P>Regards,</P><P>Nithya</P></BODY></HTML> Tue, 09 Feb 2016 06:14:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457104#M1929476 former_member225134 2016-02-09T06:14:56Z Re: Sorting Issue: https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457105#M1929477 <HTML><HEAD></HEAD><BODY><P>Hi Nitya,</P><P></P><P>Your need can be achieved by sorting the table based on Year/Month and Emp Type.</P><P></P><P>But if you do it now, it won't work since your Year\Month contains name of the month, which will reflect the sorting order.</P><P></P><P>I suggest you to add one more column which is the numerical replica of Year\Month.</P><P>For Eg: 1501 - Jan, 1505- May, 1508- Aug,....</P><P></P><P>And sort the IT based on the new column and and Emp type column, which ll achieve the required output.</P><P>Hope it helps !!!</P><P></P><P>Regards,</P><P>Deepan Swaminathan.</P></BODY></HTML> Tue, 09 Feb 2016 06:24:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457105#M1929477 deepan_v_s 2016-02-09T06:24:16Z Re: Sorting Issue: https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457106#M1929478 <HTML><HEAD></HEAD><BODY><P>And Nitya, you can use this column only for sorting purpose, and while displaying the output hide this new column. use the old Year \ Month do display the output.</P></BODY></HTML> Tue, 09 Feb 2016 06:25:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457106#M1929478 deepan_v_s 2016-02-09T06:25:56Z Re: Sorting Issue: https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457107#M1929479 <HTML><HEAD></HEAD><BODY><P>Hi Deepan,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thanks..Its working fine ....</P></BODY></HTML> Tue, 09 Feb 2016 09:31:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/11457107#M1929479 former_member225134 2016-02-09T09:31:03Z