top 4th result

[hari8088]

Hi to experts,

I have 10 records  now i want top 4th record how to write a set expression for that?

[robert_mika]

Like this:

[MK_QSL]

Max(Aggr(SUM(Sales),Customer),4)

[ankitaag]

Hi,

Please clearify

top 4th reult means 4th Row or 4th highest among all

[anbu1984]

Fourth highest customer

=If(Rank(Aggr(SUM(Sales),Customer))=4,Customer)

[hari8088]

Hi.

4th highest among all

[MK_QSL]

If you want Customer having 4th Highest Value, you need to use as below

=FirstSortedValue(Customer, -Aggr(SUM(Sales),Customer),4)

[#8]

Hi,

Please try this expression

If(aggr(rank(SUM(Sales),Customer))=4,Customer)

[Chanty4u]

samples

Re: Rank of top 5 products

[#10]

try this

if(aggr(rank(expression),dimension)<=4,dimension)