Forum Discussion
How to sort matrix based on year column in matrix (Columns are coming from date[Date])?
I am not able to sort volume in the below table by Year 2021. Year column is date column coming from in Date table. I dont want to change the stucture of the visual. Is there any other way so tha...
bsheffer
Continued Contributor
Continued Contributoryou can't, but if you move the year to the rows and amount to the values you can filter to a specific year and then you can sort the amount high to low.
I'd turn stepped layout off in row header options so your years have their own column.
Ya but we dont want to change the position of dates from columns