set analysis in static table with filters on

[ronaldwang]

As can be seen from the below structure. If in the front end, I want to show the sales from particular value from level 8. If user does not select any value from level 8 in the filter section, then I can use set analysis level8=a etc to construct the table, but once user start to make selection on level 8. The selection will not apply to the table as in the set analysis I have set level8=a already, in such instance, what will be the best way to construc the set analysis in the table so the filter will apply and the wanted information is displayed.

 

[sunny_talwar · Accepted solution]

Try with level8 *= a... read about * here

Implicit Set Operators