Calculated Field Using Prior/Current Values

2 posts, 0 answers
  1. Neil N
    Neil N avatar
    89 posts
    Member since:
    Aug 2012

    Posted 17 Dec 2014 Link to this post

    Is it possible to set up a calculated field to show the percentage difference between values of the same field?


    Jan Value    % Diff between Dec-Jan   Feb Value    % Diff between Jan-Feb    Mar Value    % Diff between Feb-Mar....
  2. Konstantin Dikov
    Konstantin Dikov avatar
    2386 posts

    Posted 22 Dec 2014 Link to this post

    Hi Neil,

    You can use PivotGridCalculatedItem and manually create the logic for your calculations on server-side, as demonstrated in the following online demo (Forecast for 1999 group):
    Detailed information on this matter is also available in the following help article:
    Hope this helps.

    Konstantin Dikov

    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.

Back to Top