Forum

Notifications
Clear all

Multi-level sorting of a pivot table

4 Posts
2 Users
0 Reactions
285 Views
(@jessica5)
Posts: 2
New Member
Topic starter
 
chart1

My pivot table is sort by the values in descending order.  For the physical sports of the same values as boxed in red, how to have a secondary sorting of the sports name?  Thank you.

 
Posted : 16/05/2025 1:13 am
Riny van Eekelen
(@riny)
Posts: 1255
Member Moderator
 

@jessica5

Sort the pivot table in ascending order by sport first, then by value in ascending order. A bar chart will then display in descending value order and keep the sports in alphabetic order.

See attached.

 
Posted : 16/05/2025 1:52 am
(@jessica5)
Posts: 2
New Member
Topic starter
 

@riny Currently I sort the values by Top 10 descending. If I sort the sports name first, I won't be able to have a secondary sorting of the values by Top 10 descending.

 
Posted : 16/05/2025 11:32 am
Riny van Eekelen
(@riny)
Posts: 1255
Member Moderator
 

@jessica5 

Ah, I see. That combination makes it difficult indeed. The only solution I can offer is by creating the bar chart from a structured data table that is custom sorted. First by value in descending order, then by sport in ascending order. Then filter the table to for the top values. In the attached file the example is for a top-5 chart.

 

 
Posted : 16/05/2025 2:02 pm
Share: