I want to create a report where it says the top 10 of my customers based on sales and the rest in an "extendable Others". Therefore the 11th customer would be called "Others" and the value would be the sum of all other customers. If i click the plus sign, it would extend the table to show what the Others -category consists of.
Is it possible to do this in Power BI? Thank you in advance!