For the attached workbook and horizontal bar chart, I need to dynamically calculate top 20 / All percentages on the runtime and display in the header.
The percentage will be based on the sales metric sum and needs to change dynamically based on the top 20.
It has to be SUM(Sales) for first 20 manufactures as percentage of total sum. Similarly if the parameter selection is all the value needs to be sum(All sales) for the sales.
Hope this helps.
Sum top 20 only
% of top 20 among total.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...