RecordCount Property Example
This example displays the number of cache records that contain "Kiwi" in the "Products" field.
MsgBox Worksheets(1).PivotTables("Pivot1") _ .PivotFields("Product").PivotItems("Kiwi").RecordCount