Compare cell value to his grand total

2 posts, 0 answers
  1. karn
    karn avatar
    15 posts
    Member since:
    Feb 2010

    Posted 08 Aug 2018 Link to this post


    how i can compare cell value to his grand total (for after change color).

    I try in CellDataBound, but how access to the grand total ?





  2. Eyup
    Eyup avatar
    4074 posts

    Posted 13 Aug 2018 Link to this post

    Hi Karn,

    Generally, please note the RadPivotGrid control does not provide custom row(item)-based logic execution and I am afraid it is not possible to get the grand total value or any of the cell values in order to calculate the final sum in the Individual Totals section. The item-based calculation logic is the specialty of the RadGrid control:

    Therefore, I am afraid this requirement is not supported with RadPivotGrid. RadGrid has something similar to what you are trying to achieve, but it is a different control:

    You can check the following resource for additional info about the RadPivotGrid purpose and functionality:

    Generally, you can use the following property for data:
    <telerik:PivotGridAggregateField ... Aggregate="Average">

    RadPivotGrid offers some neat calculation options, like the Calculation Expression (check Average Price) and the custom CalculatedItem (check Forecast for 1999):

    A detailed explanation is provided here:

    To clarify this further, I am sending a sample RadPivotGrid web site.

    I hope this will prove helpful.

    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top