Regarding Count Within Same Column

[arunutp]

Hi, 

Input : 

2018-01-01	John	Positive
2018-01-01	John	Positive
2018-01-01	John	Positive
2018-01-01	John	Negative
2018-01-02	John	Negative
2018-01-02	John	Negative
2018-01-03	Siti	Positive
2018-01-03	Siti	Negative
2018-01-03	Siti	Positive

Is it possible to count how many Positive/Negative in the same date by the same person. I tried using Multi Row Formula and still cant get the expected output as below. 

2018-01-01 John  Positive  = 3

2018-01-01 John  Negative = 1

2018-01-02 John  Negative = 2

Thank You.

[LordNeilLord · Accepted solution]

Hey @arunutp

Using the summarize tool, group by date, name & positive/negative and then count name.

This will give you the results you are looking for.

Neil

[arunutp]

Hi Neil,

Thank you so much. It works perfectly.