This is a migrated thread and some comments may be shown as answers.

PivotGrid Grouping

3 Answers 206 Views
PivotGrid and PivotFieldList
This is a migrated thread and some comments may be shown as answers.
Andrew
Top achievements
Rank 1
Andrew asked on 31 Oct 2013, 09:08 PM
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?

3 Answers, 1 is accepted

Sort by
0
Ivan Todorov
Telerik team
answered on 05 Nov 2013, 03:42 PM
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.

Regards,
Ivan Todorov
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WINFORMS.
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 >>
0
KUMARAN
Top achievements
Rank 1
answered on 23 Jan 2015, 10:20 AM
The above snippet works,but when i dropped out that field and again i select  that field  it  display as like earlier
(Ranged Groups)
0
Ralitsa
Telerik team
answered on 26 Jan 2015, 09:03 AM
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.

Regards,
Ralitsa
Telerik
 

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.

 
Tags
PivotGrid and PivotFieldList
Asked by
Andrew
Top achievements
Rank 1
Answers by
Ivan Todorov
Telerik team
KUMARAN
Top achievements
Rank 1
Ralitsa
Telerik team
Share this question
or