Show Top 5 Movies In A Text Box

[Anonymous]

I know how to do this in a table as it's a simple fix, but was wanting to display in a text box.  Table is as follows:

IMDb Top 100 Rating:           Show

1                                             Westworld

2                                             The Handmaid's Tale

4                                             Game of Thrones

7                                             Homeland

10                                           The 100

Thanks!

[ogautier62]

Hi,

=  concat( if(aggr(rank(sum( your measure)),show) <=5,show),'\n')

or if you want in order and with position :

=  FirstSortedValue(Vendeur,-aggr(rank(sum( Prix)),Vendeur),position)

regards