PivotItem.Formula Property
Gets or sets the formula for the calculated item.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v20.2.Core.dll
Declaration
Remarks
Use the Formula property to modify the formula of the existing calculated item. To add a calculated item to a specific field, use the PivotCalculatedItemCollection.Add method of the PivotField.CalculatedItems collection.
Dim worksheet As Worksheet = workbook.Worksheets("Report7")
workbook.Worksheets.ActiveWorksheet = worksheet
' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
' Access the pivot field by its name in the collection.
Dim field As PivotField = pivotTable.Fields("Customer")
' Add a calculated item to the "Customer" field.
Dim item As PivotItem = field.CalculatedItems.Add("='Big Foods'*110%", "Big Foods Sales Plan")
'Change the formula for the calculated item.
item.Formula = "='Big Foods'*115%"
For the field items that originate from the source data, the Formula property returns an empty string.
See Also
Feedback