Set analysis function using variable to ignore certain fields

[Iraa]

Hi everyone,

 I have text box using variable : 'vOrder_Volume' , I have multiple filters in my dashboard Like Country, zone, branch, Code etc. But I want to keep this  affected by only Branch and below  level selection and ignore all above level (Zone, Country) selection , How to make set analysis expression or Is there any other way to achieve that ?Can anyone please help me with that?

Thanks

[Saravanan_Desingh]

May be try like this..

Count({<Country, zone, Code>}FieldA)

This will ignore selections on Country, zone and Code.

[whiteymcaces]

What you are trying to achieve is not entirely clear, however, if you want to use a user input variable to control what selections are ignored in an expression, then you could try something like:

Sum({<$(vIgnoreSelections)>} Amount)

Where vIgnoreSelections has been set to equal Zone, Country (or what other selections you want to be ignored)

Let vIgnoreSelections = 'Zone, Country';   //in the script

You can add vIgnoreSelection to an Input Box object so users can type fields to ignore, but they must be careful to type it exactly correct.