Summarize total counts and individual counts

Question

Hi, I have a table that is like this

YearResult2009

Pass2010Pass2009Fail2010Fail2009Pass2009Pass

I wanted the result to be like this

YearTotalPassFail20094312010211

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 Answer

@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 Answer

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