I am new here, but is there a way to hardcoded pivot structure so the user did not need to rearrange pivot structure?
i want to use it as an monitoring system , so no touch on the structure
Thank you for writing to us.
We would like to confirm that there is a way to specify the pivot table structure so the user does not need to rearrange it.
To define which fields should be placed into the rows, columns, and measures, please use the Slice Object in the report.
The view and functionality available for users could be specified in the Options Object.
Please see an example that could be useful for the monitoring system case: https://codepen.io/webdatarocks/pen/ExKjeaJ.
We hope it helps.