Show all values with top 50 restriction

[sifatnabil]

Hi all,

I have a straight table with this dimension:

aggr(if(rank(sum(Revenue))<=50,Customer),Customer)

I want the table to show all 50 customers even if a customer is selected, but the table reduces to 1 row if I use this calculated dimension (even with show all values ticked). Is there a way to show all customers but still restrict to top 50? Without using dimension limits.

[Anil_Babu_Samineni]

What expression you used? May be one of these

Sum({1} Revenue)

OR

Sum({$<Customer= >} Revenue)

[sunny_talwar]

In addition to the change Anil mentioned, update your dimension to this

Aggr(If(Rank(Sum({<Customer>} Revenue)) <= 50, Customer), Customer)