Showing first n records

[deepakqlikview_123]

Hi All,'

Can you please suggest

how to show sum of quantity for first 20 city using rank function.

Thanks

[swuehl · Accepted solution]

Try (replacing City and Quantity with your field names):

=sum({<City = {"=rank(sum(Quantity))<=20"}>} Quantity)

[selvakumarsr]

For simple way.. You can use Dimension Limit "Largest" 20.

[selvakumarsr]

=aggr(if(Rank(total Sum(Quantity)=20, DimensionColumnName), DimensionColumnName)