Disable Sort on a Pivot Field

Posted by: sravya_tamma on 11 February 2020, 11:08 am EST

  • Posted 11 February 2020, 11:08 am EST


    From below example when 'County' is dragged onto columns I would like to arrange countries in certain order. Not in Ascending or descending order.

    Question 1:
    Is there a way I can turn off the sort for this field.

    Question 2: And how can I rearrange these country values horizontally.

  • Marked as Answer

    Replied 11 February 2020, 5:39 pm EST

    Hi Sravya,

    You can use the sortComparer property of the PivotField class to apply custom order to the Country or any other field. Refer to the link below:


    Regarding showing values horizontally, if you will move the Country field to the Row fields, then countries will be shown horizontally.

    Let us know in case you have any doubts.

  • Replied 12 February 2020, 5:34 am EST

    Got it, Thanks

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels