I think this example will help you. It shows the detail information about what elements are contained in the (in your case) 47.06% of products identified in your Pareto. I've downloaded this workbook before and used its functionality in my own work; I think it will be fairly easy to follow if you're somewhat familiar with Tableau already.
Thank you for looking into the issue! The link will work if I want to see in detail of the N% (in my example 47.06%) products in another sheet.
My requirement is a little different, true it should show 47.06% products, but my analysis in the other sheet, is based on another dimension which is code (in my example)
It should basically show those codes and count of products which come under 47.06%.