But what if we have to highlight top 20% of the data from X number of result with some different color.and then accumulate the numeric values associated with them
Meaning- we have X number of customers (number X is changing as per city). and their percentage of wealth compared to total percentage of wealth associated in that city.We have to highlight top 20% of those customer by showing them top 20%. and accumulate the total of their percentages as Total.
Please attach a Tableau Packaged Workbook with some sample data.