[Pivot Table] Allow sorting using dashboard filter

What is the problem or goal the end user is trying to solve or accomplish?

Pivot table sorting control by viewer of the dashboard

How are they solving it currently?

Not possible at the moment

What is the recommended solution by the Customer?

Dashboard filter to have the ability to control sorting for Pivot table