rank expression

[Romain1]

Hi everybody,

I need some help for a rank expression. I need to have a rank of my selected shop "D_ANNECY" for each field of my sector's hierarchy in my table.

Now I use this expression :

only({<[Comparatif Magasin]={'$(vMagasin_Analyse)'}>}Aggr(rank(Sum([CA HT k€ Maille])),[Comparatif Magasin]))

It work's when I just select one value for each fields of my sector's hierarchy.

When one of the fields are unselected, my expression doesn't work like I want. I don't know why.

I try this one (not good result) : only({<[Comparatif Magasin]={'$(vMagasin_Analyse)'}>}Aggr(rank(Sum([CA HT k€ Maille])),[Comparatif Magasin],Secteur,[Sous Secteur],Maille)) 

I need to have good results for my each rows of my column "RANK".

Could you give me some help ?

Sorry for my bad english.

Regards,

Romain