Summarize total counts and individual counts

[kyxz]

Hi, I have a table that is like this

Year	Result
2009	Pass
2010	Pass
2009	Fail
2010	Fail
2009	Pass
2009	Pass

I wanted the result to be like this

Year	Total	Pass	Fail
2009	4	3	1
2010	2	1	1

Where:
Total is the total count of rows per year

Pass is the total count of Pass
Fail is the total count of Fail

I tried using the summarize tool and filter but I am not getting the result I wanted.

Hope someone can point me to the right direction and tool to use.

Thank you!

[Prometheus · Accepted solution]

@kyxz You can start off with the Summarize tool to count each occurrence of Pass and Fail per year by grouping on Year and Result then counting Result. After that, you can use the Cross Tab tool to pivot the data and add your counts. A Formula tool will get your Total and then sort your data using Sort and move the columns around using Select.

 

 

 

[rzdodson · Accepted solution]

@kyxz slightly different approach to the one that @Prometheus offered, but produces the same result.

[kyxz]

Thank you, Prometheus and rdodson, both works perfect!