1 of 1 people found this helpful
There are many ways to achieve this. You can create a top set based on sales and use it in the view. After that you can add a percent of total table calculation to get its contribution.
You can create add your category field in as a filter and select the 'top' tab and select top 5 by sum of sales:
Then on your sum of sales field, add in a table calculation % of total:
Here is the final result:
Thanks and please see the attached workbook.
Top 5 Category.twbx 11.7 MB