Set Analysis Question: Top 20 customers v. everyone else

[#1]

I'd like to build some dashboards that compare the top 20 customers to everyone else. Top 20 may change depending on which filters are selected. Can this be done? How would I use set analysis to select top 20 vs. those not in top 20?

[johnw · Accepted solution]

Here's one way. I THINK the ranking will respect your other selections, but I haven't verified.

sum({<Customer={"=rank(sum(Sales))<=20"}>} Sales)
sum({<Customer={"=rank(sum(Sales))> 20"}>} Sales)