I have created a crosstab showing survey data that uses a parameter to break down the data in different ways. It looks like this:
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:
Thanks!!
Amelia
답변 5개
The breakdown calculation columns are controlled by the parameter. In the image above the parameter is set to "Gender" so the final columns in the crosstab show: Female, Male, Prefer not to say. Really appreciate your help with this!
