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:







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