It's not clear how these results derive from your sample data: specifically, it's not clear why there are two rows for ER instead of 1, and it's not clear where the 3 came from for CombID in the WR row.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA