Skip to Content
avatar image
Former Member

sorting in reports

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?

image.JPG (10.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    May 19, 2015 at 03:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 19, 2015 at 04:03 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 20, 2015 at 01:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 20, 2015 at 11:37 AM

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

    Add comment
    10|10000 characters needed characters exceeded