Hi all,

within a (Excel 2000) pivot table, I'd like to hide all items except of one, which is named 'Total'.
The item list can change, so hiding item by item does not work.The function could look like:

.PivotItem.Visible = False
.PivotItem("Total").Visible = True

I am looking for a function to hide all items at once. Any ides?

Best regards & thanks for help,
the Excelgeek