displaying top 3 records

[deepakqlikview_123]

Hello Friends,

I want to display top three recors in my output.Can you please guide us what should be the expression for this.

Thanks,

[senpradip007]

go to 'Dimension Limits' tab and select select largest 3 values. hope it will help.

[yevgeniy]

add dimentions

Grup_item

Shop_id

add calculated dimension

=Aggr(if(rank(sum([sum_sales]),4,1) <= 3,Shop_ID,Null()),[Grup_item],Shop_id).

Click suppress when value is null

add expressions

sum([sum_sales])

Rezult: 3 Shop where max sum sales