Forum Discussion

DagdasAlbag's avatar
DagdasAlbag
Helper I
5 years ago
Solved

Sort years

Hello all, can someone please tell me how to sort the years in the different columns (see picture)? I want the first column to say 2021, the second column 2020 and the third column 2019. Thanks ...
  • v-jingzhang's avatar
    5 years ago

    Hi DagdasAlbag 

    You can enter a table 'SortTable' with Year and SortOrder columns. SortOrder values are based on Year values descendingly. Sort Year column by SortOrder column.

    Then create a relationship between SortTable and Original Table on Year column.

    At last, select SortTable's Year column into the matrix. 

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.