Filtering data in a pivot table

[#1]

Hi Team - I have a pivot table with three dimensions and two calculated fields. I would like to filter out the records where Inventory Sum between 20 to 50. Since this is a pivot Chart, so the filtering should be dynamic.is there possible use slider with 2 Variables?

Any help would be appreciated - Thanks

Header 1	Header 2
Article	Inventory
00091952 00098964 00099916 00099916 00099917 00099919 00099994 00099994 00099994 13102883 13191810 13191848 13191848 13194745	13 3 5 55 2 2 100 40 10 1 20 200 1 30

[Gysbert_Wassenaar]

Please post an example document that includes a set of data that includes the other fields too.

Preparing examples for Upload - Reduction and Data Scrambling

[#3]

Thanks  a lot

[rustyfishbones]

Try this using SALES_INVENTORY_VIEW.NUM_SALE as your measure

[#5]

Thanks Alan

How can i use a dynamic range in filtering? ( Slider and 2 variables)

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[rustyfishbones]

Fantastic solution G Wassenar

[rustyfishbones]

See G Wassenar solution below

[#9]

Excellent Dears : G Wassender and Alan Farrell