01-14-2015 04:53 AM
I have a requirement for a report.
The output should be a crosstab report with total 3 columns.
1. Category(loan type,term loan, utlilization etc)
2. Months and yetd value(january14,february14....YTDFy1415)
3. $ amount.
The problem is In the crosstab report, if I give month values as character it wont be sorted in the desired order.How can I get the columns in the corrected order? I cant use the list report for this as the Month values wil get changed on a timely basis. Is there any way if we can get the months sorted in the below order (without adding prefixes)
Month values shud be sorted as below.
Jan - 14
01-14-2015 09:41 PM
thanks for the response. Now I have all the period values in one column, how can I apply the different formats? I tried creatting date variables for the variables and for the ytd columns, I gave some future date so that it comes last in the sequence. But the business would like to see the YTD column as YTD_FY13-14. How wecan achieve this? I tried user defined formats. For some reasons its not getting displayed in the infomaps