3 Replies Latest reply: Mar 18, 2011 2:48 AM by rain1111 RSS

    How to filter on an expression in a chart ??

      Hi,

       

      Here is my problem :

      Got a chart with the following datas :

      Code Production_Month_M-1 Production_Month_M
      AAA 48 0
      BBB 15 16
      CCC 12 0
      DDD 7 5

      I would see only the line with a Production_Month_M =0

      I tried this expression :

      =if((sum({$<Month={$(VMonthM)}>}[production.PROD]))=0,(sum({$<Month={$(VMonthM)}>}[production.PROD])))

      and i have :

      Code Production_Month_M-1 Production_Month_M
      AAA 48 0
      BBB 15 -
      CCC 12 0
      DDD 7 -

      instead of :

      Code Production_Month_M-1 Production_Month_M
      AAA 48 0
      CCC 12 0

       

      Thanks for your help !!!