ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   GETPIVOTDATA function on pivot filter (https://www.excelbanter.com/excel-programming/444593-getpivotdata-function-pivot-filter.html)

Greg Lovern

GETPIVOTDATA function on pivot filter
 
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)



Thanks,

Greg


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com