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;