For my project I have data with thousands of items. I have a table which is limited to top 15 best selling items in a market. The items are produced by different companies. and sorted by the total revenue made by each item (product).
I need to create a pie chart, where the dimension would be the Company name, with limit set to top 15 best items. The pie chart should present what percentage of these 15 items are produced by each company (i.e. count company name in column A in the image above).
So ideally, the chart should be sorted by Value (Sales revenue), but should present as measure the count(Company).
Can anyone suggest ways to achieve this?