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 -



      Clustered Column/Bar Chart?