Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart where I calculate the Top 10 Customers by revenue or profit. In my next chart I need to see the quantity of units sold by product for those Top 10 Customers. How do I do this when Customer is not a dimension in the second chart?
Try something like sum({<Customer={"=rank(sum(Revenue))<=10"}>} UnitsSold). Change the bold names to whatever your field names are called.