Trying to have a chart/graph showing the Top 5 Products (that's the easy part). The label I would like to show is the % for each of the Top 5 as it relates to ALL the products, not just a % within the Top 5.
Thanks in advance for any info you can share.
you can use a filter on the INDEX() function as in the attached. This way the filter is processed after all table calculations have been evaluated.
You can do the % of total calculation, then just hide the dimensions outside the top 5.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...