Sort my months descending

DeepakK
DeepakK
in Modeling

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!

Month Sort.png

Best Answer

  • BrunoRodriguez
    BrunoRodriguez
    Answer ✓

    Hello @DeepakK ,

    It seems like you are after something like this:

    image.png
    image.png

    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.

    Cheers!

    Kind regards,

    Bruno Rodriguez

Answers

  • DeepakK
    DeepakK

    @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.

  • BrunoRodriguez
    BrunoRodriguez

    Hello again!

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

    Happy to help!

    Kind regards,

    Bruno Rodriguez

Categories