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
-
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.
Cheers!
Kind regards,
Bruno Rodriguez
0
Answers
-
@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.
0 -
Hello again!
Also, remember that once done you can hide the line item!
Happy to help!
Kind regards,
Bruno Rodriguez
0