CalculatedFields.Add method (Excel)
Creates a new calculated field. Returns a PivotField object.
Syntax
expression.Add (Name, Formula, UseStandardFormula)
expression A variable that represents a CalculatedFields object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Name | Required | String | The name of the field. |
| Formula | Required | String | The formula for the field. |
| UseStandardFormula | Optional | Variant | False (default) for upward compatibility. True for strings contained in any arguments that are field names; will be interpreted as having been formatted in standard U.S. English instead of local settings. |
Return value
A PivotField that represents the new calculated field.
Example
This example adds a calculated field to the first PivotTable report on worksheet one.
Worksheets(1).PivotTables(1).CalculatedFields.Add "PxS", _
"= Product * Sales"
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.