how to get one image

[Anonymous]

hi all

i have a table where i have styles,styleimages and season.

i want just one image grouped for each style based on the highest season.

i tried

=MAX({$}aggr(distinct(styleimage),styles,season))

but its not quite working

i thought with the formula above it should output 1 style image based on the make season by style

any help would be great

thanks

[#2]

Is Season is what type of field. Can you please share some data ?

as per my understanding, you can try like below:

Only({<styles={"=Rank(Count(season))=1"}>}styleiamge)

[pokassov]

FirstSortedValue(styleimage,-Aggr(max(season),styles))

[Anonymous]

sorry but does it matter if its an expression or a calculated dimension?

sergey.. yours give me data.. when its in the expression section.. but not when its in the calculated dimension section..

[Anonymous]

its numeric.

sorry but i tried and it didnt work in either calculated dimension or as an expression.

thanks