Manual ordering of dimension values (row, column headings) in pivot tables (drag-and-drop reordering)

Is your feature request related to a problem? Please describe
Currently, pivot table rows are ordered alphabetically (by a value), but this doesn’t work for structured reports where the order of rows follows a logical hierarchy.

For example, financial reports like income statements have categories in a set order(Income → Cost of Goods Sold → Gross Profit → Expenses → Operating Profit → Other Income & Expenses → Net Income).

Describe the solution you'd like
Being able to manually reorder pivot table dimension values directly in the visualization or in the visualization settings, ideally through drag-and-drop (similar to how funnel steps can be manually ordered in the chart settings).

This would allow users to define custom sequences without touching the underlying query.

Describe alternatives you've considered
The workaround today is to build custom SQL with a manual “order column,” but this approach is brittle and hard to maintain across customers with different naming conventions (e.g., “Revenue” vs. “Income”, “Opex” vs. “Expenses”).

How important is this feature to you?
Customer:

It would literally make me cry tears of joy if we could just rearrange the order of rows somehow.

No files, tests, or entry points are identified in the issue. Start by locating the pivot-table visualization and settings code, then compare it with the existing funnel-step manual ordering; done means users can define and preserve a custom dimension-value order without changing the query.