5 Replies Latest reply: Jun 20, 2011 8:11 AM by Deepak Vadithala RSS

    Put a specific filter on a chart ?

      Hi,

       

      i have a chart with countries, month, note and sales

       

      GB : 2011/01 : 4 : 1000

      France : 2011/01 : 10 : 5000

      Germany : 2011/01 : 8 : 6000

      GB : 2011/02 : 4 : 1500

      France : 2011/02 : 8 : 4000

      Germany : 2011/02 : 7 : 7000

       

      with many more countries.

       

      I want to make a global bar graph sorted by sum(sales) with top 10.. Easy isn't it ?

       

      But the problem is i don't want to see the countries for which the avg(note) is < 5

      Thus, I absolutely don't want to see GB in this chart

       

      how is it possible ?

      Thanks