Pivot Item Object Pivot Items Collection and the Calculated Items Collection

The PivotItems collection holds the collection of individual data entries in a field. The CalculatedItems collection holds the collection of individual calculated entries in a field. Each PivotItem object represents a single entry in a data field. The parent of the PivotItems and CalculatedItems collections is the PivotField object.

The Add method of the PivotItems collection adds another item to the collection (only a Name is required). The Add method of the CalculatedItems collection adds another item to the collection but requires the Name, Formula, and UseStandardFormula parameters to be specified.

0 0

Post a comment