sorting in reports

[Former Member]

Hi Experts,

I've a report in which MonthYear Dimenstion is in the format 01-2014.

The values are stored in a Horizontal table format like 10-2014, 11-2014, 1-2015, 12-2014

How can I sort so that I've values like 01-2014, 02-2014...01-2015?

[Former Member]

Thank you guys for the pointer...It helped!!

[tanveer1]

Hi Pritesh,

Please mark the thread by selecting helpful answer or correct answer and close the thread

Thanks,

Tanveer.

[tanveer1]

Hi,

1. Create a new variable as = todate([MonthYear];"MM-yyyy") this will convert the 01-2014 as 01/01/2014

2. Now add the new variable in your table

3. sort based on new variable

4. hide the new variable

Thanks,

Tanveer

[Former Member]

Create a YearMonth dimension as:

=FormatDate(ToDate("01"+[MonthYear];"dd-MM-yyyy");"yyyy-MM")

This converts your month/year value to a date then reformats that date.

Use this in your table.

Now, if you still want to display in mm.yyyy format, apply a conditional format to show your Month Year dimension where YearMonth is not null.

[Former Member]

My guess is that this value, I´ll call it [month-year], is a Text, if so, create a variable [conc] = Right([monthyear];4)+Left([monthyear]);

take this variable onto the table and sort by it,

Regards,

Rogerio