Calculations on some columns

[David]

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!

[Viktor Tachev]

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.

• http://docs.telerik.com/devtools/aspnet-ajax/controls/pivotgrid/fields/custom-data-calculations

Regards,
Viktor Tachev
Telerik