There are a number of steps to take to accomplish what you need.
To get the top 2 products by the sum of ticket count, put Product on the Filters shelf and select Top > By Field > Top 2 > by Ticket Count > Sum
To exclude 'Others' you will need to make a duplicate of Product and put that onto the product shelf. Select the Exclude option and then tick 'Others'. You now need to make this filter a 'Context' filter, so that it applies first, before the Top 2 filter applies.
To get the top 5 Categories in each product, you need to first create a Set which allows each unique combination of Product and Category to be considered individually, and then you can sort and rank the items in view. A filter for Rank <= 5 was then used to filter out items that were not in the top 5.
There is more information on creating ranks using the INDEX function here:
Sorry forgot to attach the workbook
P.S. When you want to share your workbooks, please make sure you save them as a Packaged workbook, that way you don't need to include the underlying data as a separate file.
Sample.twbx.zip 27.3 KB
Thanks for idea..