10 Replies Latest reply on Jul 24, 2018 7:35 PM by Zhouyi Zhang

    How to sort by the column which extends to all other columns

    Dian Jiao

      I have created a crosstab sheet and selected a few fields all as "Rows". The datasource is a custom SQL. Tableau automatically grouped by first column "DOor ID". Now I want to sort the whole table by second column "Date". However the sorting only affects within the groups "Door ID". Only if I move "date" to first column, it would sort globally. But I want to keep the order of the columns with "door ID" at front. How do I sort "date" and extend it to whole table?