asked on July 8, 2020
Hi Team,
I need to set the Calculated Values Under Rows field rather than the Default functionality of adding it to the Column field. I want to do this using the flex monster APIs. Can you guide me on how to set this?
You Can check the screenshot for your reference:-
⋅ July 9, 2020
Hello,
Thank you for your question.
You are right, by default the measures are placed in columns.
This behavior can be changed by placing "[Measures]" in rows in the slice configuration.
Please see the following JSFiddle: https://jsfiddle.net/flexmonster/9ebf1c4n/.
In the example, the measures are in the "Rows" section when the report is loaded.
In case you would like to move the "[Measures]" to rows during runtime programmatically, this can also be achieved.
We have prepared an example for illustration: https://jsfiddle.net/flexmonster/x0gqdu2h/
In the example, the getColumns(), getReport(), and setReport() API calls are used.
Please let us know if this helps.
Looking forward to your response.
Kind regards,
Vera
