Choosing Bottom 5

[#1]

Hi  Experts

In my Qvw i am using the dimension Limits to Show top 10 customers for each branch

but now I want only the Bottom 5 in my top ten list of Customers for each branch

Bottom 5 in that Top 10

How can i do that

Please Suggest

[ramoncova06]

the attached example should work

[#3]

HI Ramon

I already tried this method, and its not working

Is it possible to do the restriction on Sort Tab

[#4]

Any other Suggestions Please

[ramoncova06]

not that remember

this should get it done for you

*** Edited since I missed to upload the correct version

[#6]

Hi Ramon

Actually in my data there are 152 branches

How to implement this

and my Expression Calculation is with MTD for Sales

[ramoncova06]

I was hoping your branches where a smaller number, since I normally try to avoid calculated dimensions and if, but since it seems as we do not have another option try with this

=if(aggr(num(rank(sum(sum_val), 4)), Branch,Rank) >=5 and aggr(num(rank(sum(sum_val), 4)), Branch,Rank) <=10, Rank)

suppress null values