Count value and classify

[nboccassini]

Hi,

I've a table like this:

Header 1	field1	field 2	field 3	field 4	field 5
value 1	Y	N	N	Y	N
value 2	Y	Y	Y	N	Y
value 3	N	N	N	Y	Y
value 4	Y	N	N	Y	N
value 5	Y	N	Y	N	Y

I want to obtain a table:

Class	count
Class A	5
Class B	8

where A is the count of "Y" in field 1 and field 2 and b is the count of "Y" in other fields.

How??

Thanks

[tresesco · Accepted solution]

Like this?

PFA

[MK_QSL]

Like this?

[nboccassini]

Right! Thanks

[nboccassini]

Right! Thanks

[ashfaq_haseeb]

Hi,

may be like this.

Regards

ASHFAQ