Table count

[Tommy23]

Hello,

I have this table and I would like to count the number of  time for each row its wrote Alerted. I have try to group By using the tool summarize or create a formula (IF THEN  ELSE IF)

Name	Sanction	Corruption	PEP
Client 1	Alerted	Alerted	Not Alerted
Client 2	Alerted	Not Alerted	Alerted
Client 3	Not Alerted	Not Alerted	Alerted

Results:

Name	Sanction	Corruption	PEP	Number of Alerted
Client 1	Alerted	Alerted	Not Alerted	2
Client 2	Alerted	Not Alerted	Alerted	2
Client 3	Not Alerted	Not Alerted	Alerted	1

Thanks in advance for your help!

[DataNath · Accepted solution]

Hey @Tommy23, how does this look?

The workflow:

1) Transposes the data so that all fields merge into one

2) Filters for the field value = Alerted

3) Performs a count grouped by name

4) Re-joins to the main data set

[Tommy23]

Thanks a lot it's work perfectly!!