Issue with ranking through aggr function

[Anonymous]

Hello,

I am using an aggr function to rank the top 5 values in a field however the function is only producing the top 5 rather and putting them an order. Any suggestions as to how to tweak the expression so that it gives them in order by largest value?

Thanks

=Concat(DISTINCT IF(aggr(rank(sum([field 1])),[field2])<=5,[field2] &CHR(13)))

[buzzy996]

try this,

1.properties of ur chart---sort tab---Sort by--check the CHECK BOX Y-value with descending as order from drop down, it'helps.

[hic · Accepted solution]

Try using the sort weight in the Concat() function:

  concat( expression , delimiter , sort_weight )

HIC

[sunny_talwar]

I think Shiva he is talking about the sort within the concatenate, am I right Brian?