5 Replies Latest reply on Dec 9, 2018 5:27 PM by Amelia Kohm

    How to change sorting in crosstab with a parameter

    Amelia Kohm

      I have created a crosstab showing survey data that uses a parameter to break down the data in different ways. It looks like this:

       

      Screen Shot 2018-12-05 at 3.06.51 PM.png

       

      The problem is that the sort order of the text values (both in the breakdown calculation and in the crosstab) is not what I want them to be. I tried creating a "sort order" calculation (partial image below) and then sorting both the breakdown calculation and the text values by it, but it didn't work.

       

      Any ideas? Here is the workbook:

       

      https://public.tableau.com/views/ACN_12052018/CrosstabOverviewSingleResponse?:embed=y&:display_count=yes

       

      Thanks!!

       

      Amelia

      Screen Shot 2018-12-05 at 2.55.41 PM.png