1 Reply Latest reply: Dec 13, 2017 8:24 AM by Supriya B RSS

    Chart on select data

    ra ta

      Hi, I am trying to plot a chart on a limited data. Here is an example. in the database, i have a table that looks like:

       

      countryproductsales
      Japantype110
      Chinatype211
      Malaysiatype312
      Vietnamtype413
      Indonesiatype114
      Thailandtype215

       

      I would like to plot Sales by country where product is different from type 2 and type 3, meaning i would like to limit the chart to this table

       

        

      countryproductsales
      Japantype110
      Vietnamtype413
      Indonesiatype114
      Thailandtype215

       

      Could you please suggest an expression to do this. thanks very much.