Reorder pivot columns by viewers

mceclip1.png Need 

A common requirement for self service BI is to enable the viewers to save their own report. This can be achievable in Sisense if you are a designer of a dashboard.
However, when you are a viewer, you cannot even re-order the pivot columns as you please.

 Challenge

The default behaviour of the viewer is only to interact with the filters and view the numbers. No layout changes are allowed for a viewer.

Solution

We can change the default behaviour of the viewer and allow him to re-order the rows, values & columns.
Using the API of custom roles we can achieve that. 
Solution:
Go to Admin ==> REST API ==> 0.9
PUT /roles/{idOrName}/manifest/{path} API
Fill in the following parameters:
idOrName: consumer
path: /widgets.items
manifest:
{
"reorder": true
}
mceclip0.png
Execute the API and that's it!
reorder_columns.gif
Note: the re-order option is enabled for all widget types (not just pivots), however, pivots are the main use case for this need.