[Feature Request] Sort functionality in Pivot Table v2

[cass-simplelegal]

Currently, the only way for users to sort a pivot table v2 is to sort by a metric or column in explore mode:

Is there a way to enable sorting for 'view' users who don't explore the chart? As in, have the option to sort any pivot chart v2 column in the UI itself rather than only having the current option of sorting by a metric or column?

I'm visualizing a sorting capability like the table chart already has, with the sorting arrows next to the column name:

Does anyone know if this is possible?

[SBIN2010]

Implemented in #36050