Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,'
Can you please suggest
how to show sum of quantity for first 20 city using rank function.
Thanks
Try (replacing City and Quantity with your field names):
=sum({<City = {"=rank(sum(Quantity))<=20"}>} Quantity)
Try (replacing City and Quantity with your field names):
=sum({<City = {"=rank(sum(Quantity))<=20"}>} Quantity)
For simple way.. You can use Dimension Limit "Largest" 20.
=aggr(if(Rank(total Sum(Quantity)=20, DimensionColumnName), DimensionColumnName)