Introduced in build 8.4
DescriptionThe ItemsToRetain class represents the number of items a PivotTable cache will retain even changes have been made to the data source.
RemarksSetting 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.
|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.