Question: RadPivotGrid Group Interval

[Tim]

Dear Telerik,

Thanks for the very useful function of GroupInterval in RadPivotGrid, however, is it possible to customise a threshold to grouping interval?

For example, data: 1,2,3,4,5,6,7,8. GroupInterval="Numeric" and GroupIntervalNumericRange="1".

Currently it's forced to group all the way to the end: 1,2,3,4,5,6,7,8; but I would like to have a threshold of 4 to give 1,2,3,4+. How can I do that?

Great Thanks.

[Tim]

Can't find the exact solution, but as a work around, what I've done is to create group label in the database (eg 100-200/201-300/301+), and use this identifying label for the radpivotgrid datafield instead of the actual data itself.

Thanks.

[Angel Petrov]

Hello Tim,

I am sorry to say but the current implementation of the pivot does not support such functionality out of the box. However you can log a feature request in our feedback portal and our developers will investigate the matter. If the functionality proves commonly requested it will probably be included in a future release. For now in order to make things work you can use the workaround mentioned in your last post.

Regards,
Angel Petrov
Telerik