.
Introduced in build 8.4
Description
The ItemsToRetain class represents the number of items a PivotTable cache will retain even changes have been made to the data source.C#
vb.net
Examples
C#
vb.net
Remarks
Setting PivotTableSettings.ItemsToRetain is the same as going to PivotTable Options > Data > Retain items deleted from the data source and setting Number of items to retain per field to Automatic, Max, None, or a different integer value.
Fields
Properties
Name | Description |
|---|---|
| Returns the maximum number of items the PivotTable's cache can support. | |
| Sets or Returns the current number of items the PivotTable's cache is set to retain. |