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

 

[Andrew Poulsom]

Can you do that manually? I would expect the filter to be added to a row or column field and applied to a data field. Here's an example:

    ActiveSheet.PivotTables("PivotTable1").PivotFields("Name").PivotFilters.Add _
        Type:=xlValueIsNotBetween, DataField:=ActiveSheet.PivotTables("PivotTable1" _
        ).PivotFields("Sum of % Over/Under Spend"), Value1:=-0.1, Value2:=0.1

 

[Smitty]

Please stick to your Original thread.

If you feel like it's fallen too far back to be noticed, you can always reply to it with "Bump" as the message, which will move it back to the top of the forum.