Page History

{introducedin: 8.4}


{description}
{excerpt}Sets or Returns the current number of items the PivotTable's cache is set to retain.{excerpt}
{signature:C#}
public System.String Values{ get; set; }
{signature}{signature:vb.net}
Public Property Value() As String
{signature}
{remarks}
If the {{[PivotTableSettings.ItemsToRetain]}} is set to {{[ItemsToRetain.Max]}}, {{Value}} will return the integer value of the maximum number items the PivotTable cache supports. Use {{[ItemsToRetain.Max]}} to set the number of items to retain to the maximum that the PivotTable supports.
{remarks}
{scrollbar}