TOP 1 in a TOP 3

[#1]

Hi everyone !

I want to show in a text box a TOP 1 of a TOP 3.

I a have a list, in this list i take the 3 best order by sales. In this TOP 3, I just want to show the number 1 order by the marge.

Someone can help me ?

I join an example : in the first text box it shows the top 3, but i can't calculate the TOP 1, and show this in a text box.

Thanks a lot

[matt_crowther]

Try this in a Text Box:

=firstsortedvalue(distinct AccountName,-marge)

Hope that helps,

Matt - Visual Analytics Ltd

[#3]

Thx for your answers!

But it doesn't work because i'm using rank fonction to have the TOP 3. And this function returns only the ACcountName. So if i use "firstsortedvalue", i don't have the marge colunm, so it doesn't work 😞