Custom aggregate function for winforms PivotGrid and PivotFieldList

4 posts, 0 answers
  1. nishan
    nishan avatar
    8 posts
    Member since:
    May 2015

    Posted 25 May 2016 Link to this post

    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.

  2. Hristo
    Admin
    Hristo avatar
    861 posts

    Posted 25 May 2016 Link to this post

    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
    Check out the Windows Forms project converter, which aids the conversion process from standard Windows Forms applications written in C# or VB to Telerik UI for WinForms. For more information check out this blog post and share your thoughts.
  3. Brian
    Brian avatar
    25 posts
    Member since:
    Apr 2008

    Posted 25 Jan Link to this post

    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

     

     

  4. Hristo
    Admin
    Hristo avatar
    861 posts

    Posted 26 Jan Link to this post

    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
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top