Adding Calculation Column

[Chris Bishop]

How to I add a calculation column to a pivot grid.

Col1 - Col2

[Adhikesevan Kothandaraman]

Hi Chris, 

To add PivotCalculations with the subtraction of two columns, you can use the Formula and CalculationType properties of the PivotComputationInfo. You can set the formula for compute the value of the particular column using the Formula property. Please refer to the following Code snippet,  

Code Snippet: 

// Adding PivotCalculations to the Control 

this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Amount", Format = "#,##0", SummaryType = SummaryType.DoubleTotalSum }); 

 

this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Quantity", Format = "#,##0" }); 

 

this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Sub", Format = "#,##0", CalculationType = CalculationType.Formula, Formula = "[Amount] - [Quantity]" }); 

 

 

Sample Link: 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS886384182  

  

 

Regards, 

Adhi 

 

[Chris Bishop]

Thank you so much!

That worked.

[Adhikesevan Kothandaraman]

Hi Chris, 

Thanks for your update. 

We are glad to know that your query has been solved. Please let us know if you need any further assistance. 

Regards, 

Adhi