Forum Discussion

DagdasAlbag's avatar
DagdasAlbag
Icon for Helper I rankHelper I
4 years ago
Solved

Sorting in the crosstab (column 1)

Hello, how do I get the sorting in column 1 (year 2021) descending in a crosstab? The sorting refers to the total column, see Figure 2.    
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    4 years ago

    DagdasAlbag  I meant like this, needing to create explicit measures for each year: 

     

     

DagdasAlbag's avatar
DagdasAlbag
Icon for Helper I rankHelper I
4 years ago

Thank you for your answer!
Unfortunately, there is no solution to my question.

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
4 years ago

Sorry, I forgot there's no 'tooltip' fields for matrix and tables so the workaround I use for other visuals sorting doesn't work here. I've added another reply that is long but will work. 🙂