1 of 1 people found this helpful
The first thing I did was duplicate Top5 as a crosstab. Then I dragged PercentInceaseInTimeWindow off of the Measure Values card, right clicked the Month of Order Date and deselected Show Header. Then I hit ctrl+w to swap columns and rows (still one of my favorite Tableau shortcuts!), then ctrl+dragged both Top5Flag and Product Sub-Category from the Rows shelf to the Text button in the Marks card. From here it was just a little formatting; in the dashboard I brought the crosstab out and placed it under the graphs. Then I widened the Product Sub-Category field all the way out to the right and voila! I think it's what you're going for.
The list is dynamic, and the slide filter adjusts everything. Let me know if you can get it working!
Thank for replying Vincent, that's great help! So I followed the steps and this is what I get:
And I am guessing that I cannot do way with the Months from the view? I just have to hide them by expanding the sub category label across the whole width. Right?
And If that is the case then this cannot be further modified to just a word cloud of the top 5 sub category names...
Yes, you're right. Taking the Months out of the view breaks the Top5Flag table calculation, so it must remain. Expanding the sub category field across the whole width is how you "hide" the fields to the right. This is creating a dynamic list of the top 5 sub category names, but if you wanted to do them as a word cloud we'd need to redesign the whole worksheet - there's not an easy way (that I can think of) to switch from this to a word cloud. If my initial response helped you out please mark it as helpful so that others can find it more easily. Thanks for the positive response!