Disable Sort on a Pivot Field

Disable Sort on a Pivot Field

Posted by: sravya_tamma on 11 February 2020, 8:08 pm EST

• 

  sravya_tamma

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 February 2020, 8:08 pm EST - Updated 3 October 2022, 5:37 pm 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.

  

  1403×706 61.4 KB

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 12 February 2020, 2:39 am 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

• 

  sravya_tamma

  • Post Options:
  • Link
    Copy

  Posted 12 February 2020, 2:34 pm EST

  Got it, Thanks

  Sravya