Forum Discussion

marjoriefialek's avatar
marjoriefialek
Icon for Helper I rankHelper I
5 years ago

Sort monthyear in descending order

I would like to sort a matrix column date in descending order.  I am using the 'date' hierchary  'year  'month'.  I have tried playing around with sorting that column by yyyymm, yyyy, mm, etc.   B...
Need Help
marjoriefialek's avatar
marjoriefialek
Icon for Helper I rankHelper I
5 years ago

I did that and that sort correctly but I still need to accomplish the 2 year period and in descending order.  Example

Feb2021 Jan2021 Dec2020. I can't get Dec2020 come right after Jan2021.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Himarjoriefialek,

     

    Please check in the Table view whether your data type about the date is in text format, if it is in text format, it will also cause this problem.

     

    Hope it helps.

     

    Best Regards,

    Caitlyn Yan

     

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