Pivot field filter

[adr12345]

I have this code and I want to add filter, which filters on "mobile" in field "Technology"
How to do that ?

With PT2
With .PivotFields("Technology")
.Orientation = xlColumnField
.Position = 1
End With


Thankss in adance!!!

 

[Oeldere]

Record the manual actions with the macro-recorder.

Then you get the code.

 

[adr12345]

That would be temporary solution. I would like to have dynamic syntax for it. Which should be applicable for rows as well as filters

 

[Oeldere]

After you get the code, you can amend it to your need.