I have a scenario where i have a supplier and a related <measure> say [sum(Value_US)].

I have to show the top 10 suppliers based on the <measure>. This is simple. I apply a filter for supplier and use the Top 10 by <measure> option. This is working fine.

I have to show another measure [sum (Value_US) / total (Value_US)] which is Percentage of total of the <measure>.

When there is no condition applied for Top 10, this works as expected.

When I apply condition for Top 10, Tableau calculates the percentage based on the Top 10 suppliers only. I want the the percentage to be calculated for all the suppliers present in the data. Can we do this in Tableau?

This solution is awesome, however, now that I have the top 10 filtered how do I create a "Top 10 Subtotal" row that tallies up the dollars and percentages of the data that is now being filtered? When I add Grand Total it gives the Total of all of the data, not just the Top 10. Help!