Pivot Chart - Hide other items when show detail on one item

[G0liath02]

Hi All,

I have a pivot chart with many fields and each field has many items.I am trying to code a pivot chart macro to achieve the following outcome:

When a user shows detail on a pivot field, it shows detail for that field and all other fields are hidden.
When a user shows detail on the pivot item it shows detail for that item and hides all other items.

When i say 'show detail' i mean drill down to the next level in the hierarchy I've defined, not create a new table just with that information.

I'm thinking the solution may include a For each loop but other than that I'm not really sure where to start.

Thanks in advance for your help.

Goliath

Edit -- Also posted on mrexcel.
http://www.mrexcel.com/forum/showthread.php?t=393747