Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What expression you used? May be one of these
Sum({1} Revenue)
OR
Sum({$<Customer= >} Revenue)
In addition to the change Anil mentioned, update your dimension to this
Aggr(If(Rank(Sum({<Customer>} Revenue)) <= 50, Customer), Customer)