Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Month and Year Sorting

Hi, 

 

This is probably quite an easy one, but can't seem to get it working. 

 

I have a simple table which i've imported from excel with year and month, and i'm trying to get it to sort corrently in my graphs. 

 

I've tried formatting the colums to get a number sort but it says it can't format the text?

 

Thanks for your help

Sonia

 

Need Help

7 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Try this

     

    1. Create a sepeate 12 rows * 2 column table.  The first column should have Months and the second one running numbers depicting the order of each month.  So if you Financial year is Jan to Dec, then assign 1 to Jan and 12 to Dec
    2. Create a relationship between the Month column in your base data table to the Month column of the new Table
    3. In the Base data table, Write this formula to bring over the Order from the Table created in 1 above =RELATED(Month_Order[Order]).  Rename this column as Order of month
    4. Click on any cell in the Month column of your data table and go to "Sort by Column" select Order of Month
    5. Drag the Month from the base data table.

    Hope this helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Ashish_Mathur

       

      Thanks for you reply!

       

      In another table of mine, I'm trying to sort MonthY by Monthly number , but it won't work ...

       

      any ideas?

       

      Thanks for your help!