top 5 bottom 5 syntax in expression

[dreweezy]

I've created 2 buttons which is Top 5 and Bottom 5 (using a variable). I have my expression created and it works for the most part. The problem is that it shows me 4 bars for top 5 and 3 bars for bottom 5. I was expecting it to give me 5 bars, hence the <=5 placed in the expression. Any ideas?

If(vTopBot=1,

Sum({< merchandise ={"=Rank(Sum( COST))<=5 "}>} COST ),
Sum({< merchandise ={"=Rank(-Sum( COST))<=5"}>} COST )

)

[Channa · Accepted solution]

if(aggr(rank(sum(COST)),merchandise )<=5,merchandise )

this will give top5 merchandise

[dreweezy]

Thank you. If I wanted to put both top and bot in the same formula would I do something like - 

if(aggr(rank(sum(COST)),merchandise )<=5,merchandise ), aggr(rank(-sum(COST)),merchandise )<=5,merchandise 

[Channa]

if(aggr(rank(sum(COST)),merchandise )<=5 or  aggr(rank(-sum(COST)),merchandise )<=5,merchandise )

try this 

[Channa]

=aggr(if(rank(sum(COST))<=5 or rank(-sum(COST))<=5,merchandise ),merchandise )

it should work

i am using this bro..

below one works for me

=aggr(if(rank(sum(CUSTOMS_VALUE_QAR))<=5 or rank(-sum(CUSTOMS_VALUE_QAR))<=5,COUNTRY_NAME_EN),COUNTRY_NAME_EN)