I need to summarize a set of incident data by several different stations. I have a set of five stations. The stations code emergency response using 10 incident codes, 1 being least severe and 10 being most.
I need to summarize the data so that each station has its own incident count, e.g., Station 1 had 34 incident 1 calls, 35 incident 2 calls, etc. Station 2 had 34 incident 1 calls, etc.
Essentially, I need to have a table output that has 5 rows and 10 sub-rows per main row. Is this possible?