Forum Discussion
Helper ISorting 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.
6 Replies
- amitchandak
Super User
DagdasAlbag , if you are using a column in matrix, you can only sort on the grand total of values or on row column
- AllisonKennedy
Community Champion
DagdasAlbag You haven't provided a lot of detail, but if I understand correctly, you can add a measure or column to the tooltips and that will enable you to select it in the 'filters on this visual'.
So add a measure for the value you want to sort by:
2019 Measure = CALCULATE ( [Measure], DimDate[Date] = 2019)
- DagdasAlbag
Unfortunately it did not work
- AllisonKennedy
- DagdasAlbag
Thank you for your answer!
Unfortunately, there is no solution to my question.- AllisonKennedy
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. 🙂
