4 Replies Latest reply: May 8, 2014 2:37 AM by pradeep t RSS

    Conditional count in Bar chart

    Jelly CHEN
      NameEnglish GradeMath Grade
      LilyAB
      LucyAA
      GraceBC
      JackDA
      MayAA
      GigiBA

       

      Hi I have a table show above. And I would like to show the data in a bar chart that

      (if([English Grade]='A' and '[Math Grade]'='A', count(Name))

      But I just type the above expression, the chart shows nothing. What should I modify in the expression that I could get the number I want?

       

      Thanks so much!