Set analysis respond to filter as modifier

[MindaugasBacius]

Hello,

I have expression like:

Sum(

{<

    Region = {"USA", "Asia"}

>}

Sales)

How do I make this expression to respond to the filter Region Asia?

Thank you!

[ahaahaaha]

Hi,

May be

Sum({<Region = {'Asia'}>} Sales)

[avinashelite]

What you mean by expression to respond ? if you want the expression to respond for filter you apply simply try like this

Sum(Sales)

if you want the expression to remain constant for the Asia then use Sum({<Region = {'Asia'}>} Sales)

[tresesco · Accepted solution]

May be this?

Sum(

{< Region *= {'Asia'}>+< Region = {'USA'}>}

Sales)

[Kushal_Chawda]

try this

Sum(

{<

    Region *= {"USA", "Asia"}

>}

Sales)

[MindaugasBacius]

Thank you for your answers.

I have just decided to make a trigger for my issue.

[tresesco]

None of our solutions work? Or we misread your requirement?

[Kushal_Chawda]

You should avoid triggers as far as possible. Solution suggested by me or Tresesco should work