Count something only on max value

Sophie_irp — Tue, 23 Mar 2021 08:06:50 GMT

Hello,

i want to count something on max value for to dimension, i have wrote a set analysis but doesn't work on the count.

my set analaysis :

count(distinct {<Fait_NOM={'AFFILIATION_IND_ETB'},Libelle_Produit_ORDRE={"$(=aggr(max(Libelle_Produit_ORDRE),Gamme_ID,Etablissement_ID))"}>} [_Cle_Participant])

the expression =aggr(max(Libelle_Produit_ORDRE),Gamme_ID,Etablissement_ID) work correctly but not in the set analysis.

Thanks for your help.

Sophie

topic Count something only on max value in App Development

Count something only on max value