Slider and Pivot Table

[#1]

I have two objects - a pivot table and a slider.

A slider contains a variable.
Changes in slider/variable should not affect the pivot table.
Is it possible to do that? If yes, how? Maybe with some kind of set analysis restrictions?

[ashfaq_haseeb]

Hi,

You cannot assign value to a variable like that, simple try below

sum({$<

  Phase_$(vDateType)_Month_Num={">=$(=$(vHD_MonateBack($(vDateType))))<=$(=max(Phase_$(vDateType)_Month_Num))"},

  Phase_$(vDateType)_Year_Num=,

  Digital_Sale_IND={1}

>} flagOfferOrder)

Let me know if that worked.

Edit:

Make sure your slider variable is not used in any other expressions.

Regards

ASHFAQ

[#3 · Accepted solution]

Hi!

Deleting everything in the set condition except "Digital_Sale_IND" worked.

Thanks for your support.

[ashfaq_haseeb]

Glad to know that

Can you close this thready by selecting appropriate answers.

Regards

ASHFAQ