Represents a collection of all the IPivotField objects in a IPivotTable that are calculated fields.

Represents a collection of all the IPivotItem objects that represents all the calculated items in a IPivotTable report.

Represents the memory cache for a PivotTable report.

Represents the collection of memory caches from the IPivotTable reports in a workbook.

Represents a field in a pivot table report.

A collection of all the IPivotField objects in a pivot table report.

Represents a filter applied to a PivotTable field.

Represents a collection of filters applied to a PivotTable.

Represents a formula used to calculate results in a PivotTable report.

Represents a collection of formulas for a PivotTable report.

Represents an item in a IPivotTable field.

Represents a collection of all the IPivotItem objects in a IPivotTable.

Represents a PivotTable report on a worksheet.

Represents the cell type of pivot table cell.

Represents a collection of all the PivotTable objects in the specified object.

Specifies the subtotal function.

Represents the sort type of a pivot field.

Specifies the way the specified PivotTable items appear—in table format or in outline format.

Specifies the type of layout row.

Represents the type of calculation performed by a data PivotField when a custom calculation is used.

Specifies the type of data in the PivotTable field.

Specifies the location of the field in a PivotTable report.

Represents the type of filter applied to a IPivotField

Defines grouping periods for date field on a pivot table.

Specifies where the subtotal will be displayed on the worksheet.