xlPageField Filters in Pivot Table

[sg2209]

Hi Friends,

just got stuck on the selection of Pivot Table after watching so many videos and read the queries on Forum still not knowing how to select option in xlPagefield .

[With .PivotFields("Duplicate")]
[.Orienation = xlPageField]
[.Position = 1]

[.PivotFields("Duplicate").ClearAllFilters]
[With .PivotFields("Duplicate").CurrentPage = _
"1"]

I want to Clear the Filter then only Select 1 however its now working, knidly help