Notifications
Clear all
Dashboards & Charts
4
Posts
2
Users
0
Reactions
242
Views
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
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
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