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?
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.
2 Likes
Oh wow! That worked perfectly! Thank you!
1 Like