GETPIVOTDATA function on pivot filter


Greg Lovern

Can the GETPIVOTDATA function be used to return the pivot filter?

For example, if I put the "State" field in the filter section in the
pivot designer, so that I can filter the pivot on state, and choose,
say, Oregon in the pivot's filter dropdown, so the pivot is now
filtered on Oregon, can GETPIVOTDATA return "Oregon"?

I've tried "State" and "Filter", and both return "#REF!":
=GETPIVOTDATA("State", $A$1)
=GETPIVOTDATA("State", $A$3)
=GETPIVOTDATA("Filter", $A$1)
=GETPIVOTDATA("Filter", $A$3)



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question