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

Calculations on some columns

1 Answer 68 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
David
Top achievements
Rank 1
David asked on 03 Nov 2015, 05:18 PM

Hi, there! 

I have a pivot grid with a column field which is Types of budgets, there are 3 in the SQL query: initial budget, real budget, executed value. I want two calculated fields, namely the percentage difference between the initial budget vs real budget and executed value. The result would be something like:

 INIT    REAL  Dif%  EXEC  Dif%

$1000  $900  -10%  $1100 +10%

 Is there a way to do it with custom calculated fields?

Thanks a lot!

1 Answer, 1 is accepted

Sort by
0
Viktor Tachev
Telerik team
answered on 05 Nov 2015, 03:27 PM
Hi David,

You can add calculated field and define custom calculations for them. Check out the following article that describes the approach in more detail.




Regards,
Viktor Tachev
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
PivotGrid
Asked by
David
Top achievements
Rank 1
Answers by
Viktor Tachev
Telerik team
Share this question
or