Finding Bottom x Clients

[johngouws]

Good afternoon,

I wonder if someone has the solution to my problem?

I am able to establish the top x Clients by their sales amounts, but I am having an issue with identifying to bottom x Clients.

Looking at the attached example, the slider identifies the number of Clients to show.

I believe where I am going wrong is that I first need to establish the bottom ranking, then work backwards, if that makes sense!

In the solution, when selecting top 4, I should be returning Clients L to O as the bottom 4.

Thank you in advance for your help.

Regards.

[ashfaq_haseeb · Accepted solution]

May be like this

Regards

ASHFAQ

[jpenuliar]

Hi try the below:

"-sum"

=if(aggr(rank(-sum(Amount)),Client)<=v_top,

aggr(rank(sum(Amount)),Client),null())

[johngouws]

Thank you Jonathan and Ashfaq for the answers.

A minus sign - really!!

Jonathan, unfortunately I have to give it to Ashfaq as he was slightly faster on the button!!

I really do appreciate the quick answers.

Regards - John

[jpenuliar]

lol