Hi All,
I have a requirement wherein we have to sort two columns
Time period Time Value
Monthly associated monthly values like Jan-10 to Jun-15
MQT MQT201003 to MQT201506
YTD YTD201001 to YTD201506
MAT MAT201012 to MAT201506
now time period column is always one value selected. as i select monthly in time period all associated time value come at the top and remaining (grey) values go to bottom.
Requirement is : whatever i select in time period associate time values should be sorted in ascending order which is achieved.
another requirement is on open trigger to reflect last 25 months on opening the application--achieved.
Problem is now on opening the application monthly is default value in time period. So latst 25 months come in time value. then MQT,the YTD the MAT come and later st the end comes the remaining months.
Is there a way where after 25 months i can get remaining months ......then MQT,YTD etc?
Thanks
Khushboo