Pivot Field Object Pivot Fields Collection and the Calculated Fields Collection

The PivotFields collection holds the collection of fields associated with the parent PivotTable report. The CalculatedFields collection holds the collection of calculated fields associated with the parent PivotTable report. Each PivotField object represents single field in a PivotTable report. The parent of the PivotFields and CalculatedFields collection is the PivotTable object.

The CalculatedFields collection has an Add method that adds a new calculated field to the collection, given a Name, a Formula, and a UseStandardFormula parameter.

0 0

Responses

Post a comment