CalculatedFields.Add Method

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Worksheets(1).PivotTables(1).CalculatedFields.Add "PxS", _
    "= Product * Sales"

See Also