We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to do numeric sorting in pivot grid

Platform: Silverlight |
Control: PivotGridControl |
Published Date: November 26, 2014 |
Last Revised Date: November 26, 2014

C#

this.pivotGrid1.PivotRows.Add(new PivotItem { FieldHeader = "Quantity", FieldMappingName = "Quantity", TotalHeader = "Total", Comparer = new QuantityComparer() });

 

public class QuantityComparer : IComparer

{

public int Compare(object x, object y)

{

if (x == null && y == null)

return 0;

if (x == null)

return -1;

if (y == null)

return 1;

if (Int32.Parse(y.ToString()) == Int32.Parse(x.ToString()))

return 0;

return Int32.Parse(y.ToString()) < Int32.Parse(x.ToString()) ? 1 : -1;

}

}

 

C:\Users\labuser\Dropbox\Screenshots\Screenshot 2014-06-10 15.38.41.png

Figure: pivot grid with numeric sorting

 

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon