Set analysis with more viariables

[HitcH]

Seems strange to me, but I couldn't find similar topics.

Let's consider two variables and one value:

Gender	Hair	Number
Male	Blonde	4
Male	Brown	6
Female	Blonde	6
Female	Brown	2
Female	Red	4

I'd like to select with set analysis  only "Male" and "Brown". The expression I'm using is:

sum({$<[Gender]={Male}>*<[Hair]={Brown}>} Number)

But obviously this is not working (else you wouldn't be reading this 😄 )

Any help please?

[Taoufiq_Zarra · Accepted solution]

like ?

=sum({$<[Gender]={'Male'},[Hair]={'Brown'}>} Number)

@HitcH  

[HitcH]

Thanks a lot, I found "*" on a guide on the net, I guess it was wrong 🙂

@Taoufiq_Zarra