2 Replies Latest reply: Apr 11, 2018 1:12 AM by Fei Xu RSS

    Bottom 10 in a bar chart excluding zeros

    Ramya Mudunuri

      Hi,

       

      I am trying to get bottom 10 stores on a bar chart based on the total sales but would like to exclude the store which shows 0 sales.

      For example

      StoreSales
      A10
      B20
      C40
      D30
      E90
      F0
      G0
      H0
      I0
      J0

      In this case if i try to show the bottom 5, i would get the results with F G H I J but instead i would like to see A B D C E. How can i achieve this?

      Tried using data handling> uncheck zero values..but no results