Find values that contains..

[nicolai_moller]

Hello

I have a list of operations and each operation have one or more states during a time period

Ex.

Operation:    

Alpha

Bravo

Charlie

States:

1

2

3

4

5

I want to make a list of operations that contains State 1 and 2, even if they have had other states, ex. 3 and/or 4 also.

Thanks

[Gysbert_Wassenaar · Accepted solution]

I assume you want to operations that have both state 1 and state 2. Use Operation as dimension in a straight chart object and as expression sum({<States={1},Operation=p({<States={2}>}Operation)>} 1). You can hide the expression on the Presentation tab of the properties window. Replace States and Operation with your exact field names.