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

    Hello,

    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.

    Thanks,
    Sravya.
  • 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:

    https://www.grapecity.com/wijmo/api/classes/wijmo_olap.pivotfield.html#sortcomparer

    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.

    Regards,
    Ashwin
  • Replied 12 February 2020, 5:34 am EST

    Got it, Thanks

    Sravya
Need extra support?

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

Learn More

Forum Channels