How can Apply 2 Sliders (Sale and Inventory Sliders ) to a pivot table?

[#1]

How can Apply 2 Sliders (Sale and Inventory Sliders ) to a pivot table?

For Example : "Sales between 100 and 200"  & "Inventory between 10 and 20"  ( dynamic filter)

[Gysbert_Wassenaar]

See attached qvw.

[#3]

Hi Gysbert ,

Thanks for your reply.

but i need Only filter Articles and Areas that "Sales between 100 and 200"  AND "Inventory between 10 and 20"  ( dynamic filter).

no OR condition.

[Gysbert_Wassenaar]

Then put both conditions in both expressions instead of each expression having only one condition each.

[#5]

is it correct in both expressions?

expressions1:

if( sum(DYNAMIC_EXCHANGE.CURRENT_INVENTORY) >= $(vMin) and sum(DYNAMIC_EXCHANGE.CURRENT_INVENTORY) <= $(vMax) and

sum(DYNAMIC_EXCHANGE.SALES) >= $(vMin_sale)  and

sum(DYNAMIC_EXCHANGE.SALES) <= $(vMax_sale)

,sum(DYNAMIC_EXCHANGE.CURRENT_INVENTORY))

expressions2:

if( sum(DYNAMIC_EXCHANGE.CURRENT_INVENTORY) >= $(vMin) and sum(DYNAMIC_EXCHANGE.CURRENT_INVENTORY) <= $(vMax) and

sum(DYNAMIC_EXCHANGE.SALES) >= $(vMin_sale)  and

sum(DYNAMIC_EXCHANGE.SALES) <= $(vMax_sale)

,sum(DYNAMIC_EXCHANGE.SALES))

[Gysbert_Wassenaar · Accepted solution]

That looks correct.