First Sorted Value

[#1]

Hi,

I'm trying to use the first sorted value function to return the overall winner of a test we're running. The table below shows the data I'm working with:

The winner of this test has the highest Prejoin>Join ratio, which in this case is Theme 3200. I'd like to return the value 3200 in every row in the column 'Overall Winner'. I'm using the following expression without success:

=FirstSortedValue(Themes, -Aggr(sum(vCTR),Themes))

vCTR is simply a variable storing the quotient of Join/Prejoin. If anyone has an idea on how to solve this that would be great. Sample data attached.

Thanks.

Matt

[Nicole-Smith · Accepted solution]

This should do the trick:

only({<Themes={'=rank(sum(CT)/sum(C),0,1)=1'}>}total Themes)

[#3]

Works like a charm, thanks so much for the help!

Matt