Sort my months descending


Hello all,

I have a standard module that will show data by month. But I would like to Sort it starting from Mar 23 and go backwards. How can I make this happen?

I was thinking of putting a Sort number in every single column with a date in it. I want it to flip in the screenshot below. Thanks!

Best Answer

  • BrunoRodriguez

    Hello @DeepakK ,

    It seems like you are after something like this:

    Just create a Line item with PERIOD(START()) - it can be a subsidiary view, given that it only needs time as dimension. Apply the sort over the line item.


    Kind regards,

    Bruno Rodriguez


  • @BrunoRodriguez YOU DA MAN!! Thank you so much. This is an elegant solution that's easy to do.

    The only thing different I did was to add the column in the UX grid and sort descending from there. Then I can hide the column while the sort still stays.

    Appreciate you.

  • Hello again!

    Also, remember that once done you can hide the line item!

    Happy to help!

    Kind regards,

    Bruno Rodriguez