Set analysis Product using rate

[#1]

Hello,

     I've a hierachical dimenssion composed of 3 dimensions (Direction commercial \ Nom Secteur \ Libelle Agence) and I would like to calculate the customers products using rate (<Count of Customer using a product> / <Count of customer at hierachical level>) for each level.

Can you help me to compute the count of customer for each level in table (red column) and chart .

Thanks

[Gysbert_Wassenaar]

Try count(total <$(vG) > [N-Personne]) with a helper variable vG with value ='['&GetCurrentField([>>Maillage])&']'

[Clever_Anjos · Accepted solution]

First, rename your group, I think GetCurrentField didn´t like your '>>' name

I renamed to HG_Maillage and used the below expression:

if(GetCurrentField(HG_Maillage) = 'Direction commerciale',

          count(total <[Direction commerciale]> [N-Personne]),

          if(GetCurrentField(HG_Maillage) = 'Nom Secteur',

                    count(total <[Nom Secteur]> [N-Personne]),

                    count(total <[Libelle Agence]> [N-Personne]),

          )

)

[#4]

It looks good. Thank you very much