Each PivotField object has a Pivotltems collection associated with it. You can access the Pivotltems using the Pivotltems method of the PivotField object. It is a bit peculiar that this is a method and not a property, and is in contrast to the Hiddenltems property and Visibleltems property of the PivotField object that return subsets of the Pivotltems collection.
The Pivotltems collection contains the unique values in a field. For example, the Product field in the source data has four unique values— "Apples", "Mangoes", "Oranges", and "Pears", which constitute the Pivotltems collection for that field.
Was this article helpful?