Set analysis: ignore, but don't ignore

[jphillipsepg]

So I'm hitting a stumbling block.  I am trying to analyze the on time for all operators ignoring the filter of a chosen operator. This part, I've figurned out..

Sum({<[Operator Name]=, [Op Login Type]={'Operator'}, [Op OnTime])

My challenge now, is that I have operator sub sets.. Operator, Office Employee, Trainee, Supervisor.  I want to evaluate the time for all operators while still ignoring the filter, and exclude Operators belonging to Office Employee ad Trainee.

Sum({<[Operator Name]=, [Op Login Type]={'Operator'}, [Operator Group]-={'Office Employee'}, [Operator Group]-={'Trainee'}>}[Op OnTime]) 

This is what I tried, but it is not working.  I'm guessing I need to embed a layer of set analysis within the other analysis?

Any help would be deeply appreciated.

Thank you

[sunny_talwar · Accepted solution]

Try this

Sum({<[Operator Name], [Op Login Type] = {'Operator'}, [Operator Group] = e({1<{'Office Employee', 'Trainee'}>})>} [Op OnTime]) 

or this

Sum({<[Operator Name], [Op Login Type] = {'Operator'}, [Operator Group] = -{'Office Employee', 'Trainee'}>} [Op OnTime])