Sort by is not working for Pivot Table and Pivot Table V2 chart

[bonamim]

Sort by is not working for Pivot Table and Pivot Table V2 chart.

How to reproduce the bug

1. Create a [Pivot Table] or [Pivot Table V2] chart;
2. Add some fields in Row section and one metric in the Metrics section;
3. Try to sort the data using the metric.

Expected results

When SORT DESCENDING is selected, the data in the pivot table should be in descending. It is possible to see in the images below that the sorting is respected in the Results section, but in the pivot table nothing happens.

Actual results

• Pivot Table

• Pivot Table V2

Environment

• browser type and version: Chrome (Version 110.0.5481.177)
• superset version: superset version 2.0.1
• any feature flags active:
  • ENABLE_TEMPLATE_PROCESSING
  • DASHBOARD_RBAC

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
• [x] I have reproduced the issue with at least the latest released version of superset.
• [x] I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

• Helm Chart;

[Sansinj]

Same problem here :(

[HeathLee]

Same problem

[smiren]

Same problem

[smiren]

The same problem here

[gajendersingh1982]

Same problem seen by me

[seantdinh]

same here :( , please fix because it makes the table not usable for the user to quickly look at a lot of data

[rusackas]

Can anyone validate whether or not this is still an issue in 3.x or newer versions? We no longer support 2.x, so I'm tempted to close this as stale, but if we can get a working failure case for 3.x using example/sample data, that'd be great.

[ProdigyMaster]

@rusackas The issue remains the same: sorting in pivot tables doesn't work, as it displays data in a random order.

[cmcnicoll]

I'm seeing the same issue in Preset version 2024.8.2. The query that runs is correct, but the pivot table sorts in ascending order for this example:

SELECT DATE_TRUNC('month', order_date) AS order_date,
       state AS state,
       COUNT(*) AS count
FROM public."Vehicle Sales"
GROUP BY DATE_TRUNC('month', order_date),
         state
ORDER BY 1 DESC
LIMIT 10000

[lindsay-kk]

same issue, can we pls have a patch for this in the next updated version

[liany-dropit]

We have the same issue

[swami-kf]

We too have encountered the exact same issue!

[jamzl]

Same here!

[eliaetzensperger]

Same here!

[rtotheb2000]

Same here! Any known workaround?

[zlzdmv2022]

Same here! Still in 4.0.2

[ngocdd]

same problem here: Version: 4.0.2

[kpiforgeoliver]

Have tried 4.0.1 and 4.0.2 still no ability to sort except alphabetic or numeric sorts of the first column. It's quite ridiculous that a chart as basic as a pivot table cannot have a column sort that works.