Can I Get Pivot Filter Choices without VBA

[davegugg]

Hey

Is there any way I can use a formula to get a pivot table's filter choices? For example, if I have region and Pivot Table 1's filters show Northeast and Southwest, can I use a formula to get those two values? Something like =PivotTable1.Filter.Value.

Thank You

[DonkeyOte]

I am wary of saying "no categorically not" but I would be surprised...

The built in Pivot cell Function is tied to the Data Fields, to retrive values from Page, Row or Column fields is traditionally with likes of INDEX/MATCH etc and then of course you are limited to single cell selections (ie could not handle Page field multi selection).

Where exactly are the filteres of interest ? Page, Row or Column ?

[JosephP]

not in 2007. in 2010 there are workarounds you can use with slicers though they tend to be a bit clumsy

[davegugg]

Thanks for the answers:
DO, they are Report Filters.
JosephP, I actually do have slicers on the pivots, but I've still been unable to get any solutions to work. Do you have any more info on the clumsy workarounds?

[JosephP]

there's a sample here http://www.powerpivotpro.com/2011/09...-in-a-formula/
there is also a link on that page to a neater method if you can use powerpivot (or excel 2013)

[davegugg]

Thanks, there is a complication that prevents me from using the method in the link you provided, but I was able to convert my pivot table to a powerpivot table, and use that method.