Hi,

I have a Pivot Table that looks something like this:

#------Name------Product
1------Alpha-------
-----------------------A
-----------------------B
-----------------------C
2------Beta-----------
-----------------------B
-----------------------D
------------------------E

Now, I can loop through any one item and change the ShowDetail to minimize it. The problem is that what I want is to change the ShowDetail to False for the Pivot Field called 'Name', but as my criteria, I need to look at the # field.