Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

sort month

Hello, There is a month column which i am using in a slicer. it shows the month in alphabetical order however i want it in month number order. I also have a month number column which I am not usin...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

     

    This will be reflected in you reports.

    Thanks
    Mariusz

  • sdjensen's avatar
    sdjensen
    7 years ago

    You have to do it in your data model - why would you ever want your months to show in anything else than the correct order?

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

You can sort your Month Names by month numbers, providing you do have a month number column.

Please see the below.

 

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi, thanks for the email

    Please read my post clearly and you will see that I would like to do this on report rather than the dataset.

    Thank you

    • Mariusz's avatar
      Mariusz
      Community Champion
      7 years ago

      Hi Anonymous 

       

      This will be reflected in you reports.

      Thanks
      Mariusz

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        yes, i am aware of that but is there a way to do this just on report and not in dataset?

    • sdjensen's avatar
      sdjensen
      Solution Sage
      7 years ago

      You have to do it in your data model - why would you ever want your months to show in anything else than the correct order?

      • sdjensen's avatar
        sdjensen
        Solution Sage
        7 years ago

        Thank you for accepting my answer as a solution, but you should really give the credit to Mariusz