3 Replies Latest reply on Mar 3, 2015 4:26 AM by panjala Srinath

    top-5 items in a side by side bar chart (or a clustered bar chart)

    Prashant Jani

      I have to do the following two tasks -

      a) Display top-5 items based on sorting of a measure. (Example: "Current month accuracy - abs" measure as shown in attached file, sheet "WorseFcst SKU-1")

      b) For these top-5 items, I need to build a side-by-side bar chart or clustered bar chart that shows two other measures. (Example: sales and forecast as shown in attached file, sheet "WorseFcst SKU-2")

       

      I know how to do both (a) and (b) separately. But I could not do both in a single worksheet.

       

      PS: I already tried the following threads -

      http://kb.tableau.com/articles/knowledgebase/finding-top-n-within-category

      http://kb.tableau.com/articles/knowledgebase/nestedsorting

      Clustered Column/Bar Chart?