I have a specific scenario where in I need to create a calculated field which will be division of "sum of sales for all countries(for all products)" and "sum of sales of for top 30 products by sales for all countries". So what I mean here is "sum for top 30 products/sum for all products". I am not able to find a solution for this.
I cannot apply filter since on product since it will affect the whole sheet.
Is it possible to achieve this in tableau? I have attached data set for reference.
To add here, I need only the final % value for above calculation which i need to display in a dashboard.