how to avoid a branch name from top 5 and bottom 5 expression

[venkat1]

while doing top 5 bottom 5 scenario,i got a doubt to how to avoid a branch name in expression.

i have an expression

 =if(Aggr(rank(-sum(sale))<=5 ,BRANCH),BRANCH)

if  i want  not to show 'delhi' in top 5  then how can i do this ?

[Arthur_Fong]

Try this:

if(Aggr(rank(-sum({<BRANCH-={'delhi'}>}sale))<=5 ,BRANCH),BRANCH)

Thanks and regards,

Arthur Fong

[Brett_Bleess]

Venkatesh, did Arthur's post work for you?  If so, please consider using the Accept as Solution button on his post to give him credit as well as let others know this was the correct solution.  

Regards,
Brett