Pivot Tables Report filter

[David Evans]

Can you reference the value of the report filter using GetPivotData, or something similar? if you just reference the cell, and you change the table, that reference is lost.
I've been looking for info on it to little avail ...

 

[wudixin96]

function GETPIVOTDATA

 

[David Evans]

function GETPIVOTDATA

Hmm - thanks.

Anyone else been able to give this a little more thought and consideration?

 

[dan_l]

I don't think there's a way to do this with get pivot data and I can't really think of another way to do this.

My "best practice" for this is to just express the whole pivot table and make clever use of grouping instead of messing with the filters.

 

[David Evans]

I don't think there's a way to do this with get pivot data and I can't really think of another way to do this.

My "best practice" for this is to just express the whole pivot table and make clever use of grouping instead of messing with the filters.

I believe you are correct about the GetPivotData - I think I can do it via VBA as I'm able to use VBA to set the Report filter Value in another model ...

Thank you for giving it some thought - Appreciated!

 

[dan_l]

iirc, you set the pivot table filter by addressing the cell where the pivot table is---that's fine---but still if you change the pivot table like reordering the filter you might just end up with the same problem in your initial post.