How do I sort columns in Pivot Table by a specific order?

I have a Pivot Table I’m using to display the results of a LIkert responses to a question (Strongly Agree, Agree, Neither Agree or Disagree, Disagree, and Strongly Disagree). I want to sort the table in the respective order, but I don’t see that option. I was wondering if this community has found a solution?

Screen Shot 2021-10-22 at 4.13.28 PM

You can create a calculated field and use a nested ifelse to express your desired order as a number.

ifelse({Readable_Response} = 'Strongly Agree',5,
ifelse({Readable_Response} = 'Agree',4,
ifelse({Readable_Response} = 'Neither Agree or Disagree',3,
ifelse({Readable_Response} = 'Disagree',2,
ifelse({Readable_Response} = 'Strongly Disagree',1,0
)))))

Then you can sort the column dimension by the calculated field you created.

1 Like

Oh wow! That worked perfectly! Thank you!

1 Like