Selector Ignore Another Selection

[wonkymeister]

I have a selector that I want to ignore the selection of another selector on a dashboard.

The dimension available to select: pay_grouping_types

The field in the other selector (which is always one selected) that I’d like to ignore: %month

I thought this would work but obviously doesn’t (result leaves no values available to select)

if(Only({$<%month=>} pay_grouping_types) <> 'Others', pay_grouping_types)

Any ideas guys?

[sunny_talwar]

May be try this

Aggr(Only({1<%month, pay_grouping_types = -{'Others'}>} pay_grouping_types), pay_grouping_types)

[sunny_talwar · Accepted solution]

Or this

if(Only({$<%month=>} pay_grouping_types) <> 'Others', Only({$<%month=>} pay_grouping_types))

[vitaliichupryna]

Maybe I don't understand what you want, but if you want have independent selectors you  can use alternate states

[wonkymeister]

still not working, still restricting on %month - i cant understand why though

[sunny_talwar]

Would you be a able to share a sample or sample image to show what you have?

[wonkymeister]

i cant i'm afraid - its restricted payroll data.

i think your examples should work fine - i think that maybe there is something else in the model interfering with this data.