4 Replies Latest reply: Jan 15, 2012 9:32 AM by Guy Davidovich RSS

    Not able to sort correctly a top 10 in a bar chart

    Guy Davidovich

      Hi,

       

      I try to show 10 customers that are sorted by their revenue in ascending order, but only to customers that their revenue was more then 200$.

      (so, in other words, I want to show my customers with the lowest revenue, but only to those that their minimum revenue is more then 200$) ,

      so i use this expression :

       

      =IF( Sum(revenue) >= 200, Sum(revenue), Null())

       

      and then i sort by setting the Y-Value to Ascending, and in the Dimension Limit tab i choose to show only the smallest 10 values.

       

      but what i get is like this:

       

      Bar Chart.png

      all the 9 left empty bars were not supposed to be there, only the right bar stands for the criteria of revenue more than 200$.

       

      Please help me to do this correctly.

       

      Thanks,

      Guy