How to show the best Year from a ListBox

[#1]

Hi all,

i want to show a Year with the Most frequency in Ttilte Bar form a ListBox.

I have these Script in the Title bar!

 ='» Top: ' & max(aggr(count(distinct id),myYear)) & ' in ' ???

How can the add the year 2007 in the title bar

Thanks

[#2 · Accepted solution]

Hi there, try the following expression:

=concat({$<Year = {"=rank(aggr(count(distinct id),Year),1,1) = 1"}>} distinct Year,',')

This expression also considers the case in which more than one year share the same count of id's, displaying each year separated by a comma.

Regards