VBA, Using Conceptual Filters in PivotTables

[aallaman]

Hi All,

I'm trying to get my pivot table to respond to a VBA command to filter based on a xlValueIsNotBetween filter type. But I keep getting a Run-time Error '1004': Application-defined or object-defined error

Here is the code I'm using. Can anyone give me pointers on why this isn't working???

PT.PivotFields("% Over/Under Spend").PivotFilters.Add Type:=xlValueIsNotBetween, _
Value1:=-0.1, Value2:=0.1

 

[texasalynn]

does it work manually?

 

[aallaman]

Hi ,

"Can I do it manually?" Good point. Just checked and I cannot. The filter only lets me filter the 'top ten' not the other conceptual filters.

Why would those filters be disabled?

Is there any work around?

Thanks

Allen