We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

How to sort rows for total sum?

Answered

Hi, How to sort rows for total sum?
Please check the case of my attached picture.
thanks.

1 answer

WebDataRocks Team WebDataRocks August 28, 2020

Hello, David!
 
Thank you for reaching out to us.
 
Our team wants to explain that sorting does not affect the order of measures.
Sorting is performed within one measure, ordering corresponding members of the field. In your case, no fields are chosen for columns. As a result, sorting does not affect the grid. Please try placing an additional hierarchy to columns in order to learn how sorting by values works in Flexmonster.
 
In case the order of measures needs to be changed, the Slice Object should be used.
Measures will be ordered in the same way they are placed in the measures array of the mentioned slice object.
 
We hope it works for your case.
Please contact us in case other questions arise.

Regards,
WebDataRocks Team