Hi,
Could anyone teach me how to keep top 20% of user group showing in a bubble chart with x and y axis? 20% is based on the number of users. Is it possible to do it?
For example, how can I only keep top 20% bubbles (relatively bigger size) in this graph:
2 answers
You can achieve this using the RANK_PERCENTILE() function (Table Calculation) I've attached a workbook as an example.
The calculation I used is:
RANK_PERCENTILE(SUM([Sales])) > .799
Applying it to color, and calculating it by customer name gives me the following result:
