Determine Selected Pivot Table Page Range Filters

I'm trying to find a way to determine which items have been selected to Filter a Pivot Table at the Report filter Level.

In the immediate window, I've gotten as far as finding that:

Please Login or Register  to view this content.

What I'm after is what those "Multiple Items" are So that I can display them elsewhere on my sheet. IN my example, I'm using the Report filter selection to facilitate turning on and off different "Options" from the data set. So the user can use the check boxes to have "Option A' , and "Option C" displayed simultaneously for example.

I want to be able to pull whatever choices the user as selected. Any ideas on how to do this?

Thanks,

Shred

The terminology used in the above implies you're using a version >= XL2007 in which case you will find you can iterate the various Items of the various Report Filters and test the visible status of each
(you can not do this pre XL2007 without modifying the orientation of the report filter)

There are quite a few posts around regards controlling multiple pivots from one, which though are not relevant here, do contain the various bits you're interested in...
ie looping the report filter items, validating which Items are visible etc...

http://www.excelforum.com/2190122-post8.html