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"