add ability to manually change sort on reports for string fields

Hi,

We already support sorting on the non pivoted field in the pivoted reports. If you want to sort the columns themselves, unfortunately, there is no way. Pivoted report often are heavy queries which take a while to process data when you query. We cannot support multiple operations which we support for non pivoted reports and guarantee a decent load time. Most of the pivoted reports might just time out. 

What I’d recommend is to pivot the data using one of our data preparation tools (Data Designer) and then run the report on it. This way, we are pre-computing and are not computing everything when a user visits a dashboard and hence can support complex calculations.