Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Custom sorting for dimension values

Rodrigo Demicheli asked on March 9, 2018

Hi, i am testing the pivot, is there a way to set a custom sort function  for the dimensions (rows or columns) values, so I can override the alphabetical (a-z or z-a) order and force some values to be kept always to the end or to the start of the list of values?
Thank you
Rodrigo

1 answer

Public
Dmytro Zvazhii Flexmonster March 12, 2018

Hello Rodrigo,
Thank you for your question. The custom sorting function for the dimensions is not supported. However, you can pre-define the dimension’s order before loading the report. Just use “sortOrder” property for this. Here is the example – https://jsfiddle.net/flexmonster/39z1xy8y/.
Let us know if it solves the case.
Regards,
Dmytro

Please login or Register to Submit Answer