Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)