Count with 2 parameters in a age structure

[AlbanMONTBILLIARD]

I tried to make an age structure (pyramide des ages in french) but i have more result in it than i want. 

The expression than i use is 

count({<SEX={"M"}>+<MONTH="202008">}SEX)

but the result contain all the men in all the month.

Where are my error ?

Thanks for you're help

[edwin]

try it with a comma:

count({<SEX={"M"}>,<MONTH="202008">}SEX)

[Taoufiq_Zarra]

@AlbanMONTBILLIARD 

avec le plus dans Set si la condition Sex=M est Ok donc pas besoin d'aller plus dans le Set analyisi (si la syntaxe est ok aussi)

si j'ai bien compris tu as besoin de :

count({<SEX={"M"}, MONTH={"202008"}> } SEX) , sinon est ce que tu peux partager un exemple de data avec ce que tu souhaite comme output ?

[Kushal_Chawda]

@AlbanMONTBILLIARD  try below 

count({<SEX={"M"},MONTH={"202008"}>}SEX)

[AlbanMONTBILLIARD]

Thanks a lot. That's good

[AlbanMONTBILLIARD]

I try to extend the problem and remplace "202008" by max(month) but that not match. Why ?

[sunny_talwar]

Try this

Count({<SEX = {"M"}, MONTH = {"$(=Max(MONTH))"}>} SEX)

[Taoufiq_Zarra · Accepted solution]

@AlbanMONTBILLIARD  May be :

=count({<SEX={"M"}, MONTH={"$(=Max(MONTH))"}> } SEX)

[AlbanMONTBILLIARD]

Thanks a lot you two. You're the best