PivotGrid Grouping

4 posts, 0 answers
  1. Andrew
    Andrew avatar
    1 posts
    Member since:
    Oct 2013

    Posted 31 Oct 2013 Link to this post

    Is there a way to turn off grouping of items with the pivot grid.  I'm passing in a dataset with hundreds of rows containing a numberical ProductID column.

    When I place this ProductID into the row labels section it automatically groups the products into two ranged groups.  We need this data at a more granular level.  Is this possible?
  2. Ivan Todorov
    Ivan Todorov avatar
    688 posts

    Posted 05 Nov 2013 Link to this post

    Hi Andrew,

    Thank you for contacting us.

    When using numeric fields the RadPivotGrid automatically creates DoubleGroupDescription which is suitable in the case when the numeric field represents some kind of measure. The DoubleGroupDescription uses its Step property to determine the value range in which entries will be grouped. If you want to prevent grouping at all, you should use the PropertyGroupDescription which puts in the same group only entries with the exact same value. The following snippet demonstrates how to add a PropertyGroupDescription:
    this.radPivotGrid1.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "EmployeeID", GroupComparer = new GrandTotalComparer() });

    I hope this will help you. Please let me know if you have any further questions.

    Ivan Todorov
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
    KUMARAN avatar
    28 posts
    Member since:
    May 2014

    Posted 23 Jan 2015 in reply to Ivan Todorov Link to this post

    The above snippet works,but when i dropped out that field and again i select  that field  it  display as like earlier
    (Ranged Groups)
  4. Ralitsa
    Ralitsa avatar
    192 posts

    Posted 26 Jan 2015 Link to this post

    Hi Kumaran,

    Thank you for contacting us. 

    You can refer to the following forum thread Pivot Grid Row Label which contains code snippet and sample project. 

    Hope this will help you. Let me know if you have any another questions.


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top