Conditional count in Bar chart

[#1]

Name	English Grade	Math Grade
Lily	A	B
Lucy	A	A
Grace	B	C
Jack	D	A
May	A	A
Gigi	B	A

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!

[maxgro · Accepted solution]

in bar chart

dimension          Name

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

[ferha_jafri]

Try this,

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

[#4]

Yes! It looks good now. Thanks so much!

[PradeepReddy]

we can achieve this using set analysis also...

count({$<[English Grade]={'A'},[Math Grade]={'A'}>}Name)