Count a column depending of its value

[machm384]

Hi, I am trying to count how many 1s are there for  each value of column GSD_SA

I should get for X  a value of 3

and I should get  for Y a value of  6

I am using     count({<UNDER_25={'1'}>} GSD_SA_ID)     but I am getting a weird result. Ideas?

GSD_ACCT_ID     GSD_SA_ID     UNDER_25

1	X	0
1	X	0
1	X	1
1	X	1
1	X	1
1	X	0
1	X	0
1	X	0
1	X	0
1	X	0
1	X	0
1	X	0
1	X	0
2	Y	1
2	Y	1
2	Y	1
2	Y	1
2	Y	1
2	Y	0
2	Y	1
2	Y	0
2	Y	0
2	Y	0

[sunny_talwar]

Have you just tried Sum(UNDER_25)?