Custom aggregate function for winforms PivotGrid and PivotFieldList

[nishan]

Dear Telerik,

I am using winworms PivotGrid and PivotFeildList.

In the PivotFieldlist I want to have more aggregate functions like upper quartile and lower quartile.

Plese let me know if it is possible to make a custom function.

Thanks,

Nishan.

[Hristo]

Hi Nishan,

Thank you for writing.

We have a documentation article providing detailed information how custom aggregate functions can be created and used in RadPivotGrid: Custom Aggregation.

If you follow the suggested in the article approach you would be able to display the custom aggregate in the field list control associated with your pivot. Adding this function to the aggregate options dialog is, however, more tricky. That is why I have extended the example to include a solution handling this scenario. The default dialogs used in RadPivotGrid can be substituted by creating a dialog factory: Customizing the Dialogs.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo Merdjanov
Telerik

[Brian]

Hi

I would like to find the last value. i.e. the cells underlying rows should be sorted by a date column. The result should be a string based on values in the last row (several columns), e.g. < 27.3, where < is stored in one column and 27.3 in another column.

Brian

 

 

[Hristo]

Hello Pavel,

Thank you for writing.

As of our 2017 R1 release, we provide an API for extracting the underlying data taking part in the calculation of the values displayed in RadPivotGrid: Drill Down.

In case you need further please provide me with more details about your scenario and what you are trying to achieve.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo
Telerik by Progress