How to sort on the second column in a pivot table visual?

Question & Answer
,
1

Hi,

I am using a pivot table visual. I have several columns. I would like to sort on the second column.
Is there a way to do this? Looks like it always sorts on the first column. I want to sort on the second column only.
Thanks in advance

2

Hi @gopinathpc
you could apply the sort on the first column but use the second column field as sort option.
BR

3

Hi,
I see only “off -visual field” in the sort option. When I give the second column in the off-visual field it does’t sort on my second column.

Screen Shot 2024-05-09 at 6.39.53 AM
Screen Shot 2024-05-09 at 6.39.53 AM1164×320 54.1 KB

4

Can you share a screenshot?

5

I had attached the screenshot to my previous message.

6

Hi @gopinathpc, maybe you can try this approach Sorting by multiple columns or

sorting-pivot-tables3

I am marking this reply as, “Solution,” in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)