10 Replies Latest reply: Jul 16, 2018 6:17 AM by Girish Gupta RSS

    sum of something with if conditon

    Girish Gupta

      i want sum of values

      i have

      compaNY NAME
      AMOUNT
      ABC10
      BTY20
      ATE10
      ZYS50

       

      I WANT THE SUM ON ABC BTY AND ATE WHICH IS 40 IN A BAR

       

      THE FOLLOWING CODE:

       

       

      Sum({$<COMPANY_NAME = {"A*","B*"}>}AMOUNT)

      in bar chart but i am getting all the bar of company name starting from a and b

       

      thanks in advance