This is a migrated thread and some comments may be shown as answers.

Calculated Field Using Prior/Current Values

1 Answer 12 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Neil N
Top achievements
Rank 1
Veteran
Iron
Neil N asked on 17 Dec 2014, 11:50 PM
Is it possible to set up a calculated field to show the percentage difference between values of the same field?

Example:

Jan Value    % Diff between Dec-Jan   Feb Value    % Diff between Jan-Feb    Mar Value    % Diff between Feb-Mar....

1 Answer, 1 is accepted

Sort by
0
Konstantin Dikov
Telerik team
answered on 22 Dec 2014, 12:47 PM
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.


Regards,
Konstantin Dikov
Telerik
 

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.

 
Tags
PivotGrid
Asked by
Neil N
Top achievements
Rank 1
Veteran
Iron
Answers by
Konstantin Dikov
Telerik team
Share this question
or