Filter Values in Pivot Filter Field in Excel by condition

[srehman]

Hi Team,

As in attached snapshot.

In pivot table FILTER Field i have to filter values between example condition (1000 to 10000)$, But this field has thousands of values.
Currently i manually tick & Untick the values . All going good but too much manual and time consuming process.


I don't want to do it by traditional method by using condition formatting or adding any extra helper column.

Is there anyway without moving this field from FILTER , i can achieved my results. or by ( Pivot Measures)

Any thoughts.
Thanks in advance.

 

[mrshl9898]

Filter on the column, Value Filters, Between

 

[srehman]

Nop i am talking about Filtered Field of Pivot table pls recheck snapshot