Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getpivotdata....showing filter | Excel Worksheet Functions | |||
two pivot q's - get rid og getpivotdata and pivot based on pivot | Excel Discussion (Misc queries) | |||
create pivot table formula without the GETPIVOTDATA function | Excel Discussion (Misc queries) | |||
Can a pivot table function like data filter? | Excel Programming | |||
Can a pivot table function like data filter? | Excel Programming |