I have a field that gives a "0" (false) or "5" (true) for "if meets goal".
I would now like to be able to summarize how many of the "0" and "5" there are for a specific group or Service Area. For example, the main field is Service Area and the Service Area can have tens to hundreds of rows of data (see below):
Aquatics Swim class 1 0
Aquatics Swim class 2 5
I have tried creating s summary report but it will only total the 0 and 5's. I then tried to "define a calculated column" but can seem to find a formula that will work (I am a novice at this...). What I want to show is how many "0" there are and how many "5" there are by Service Area (maybe by total AND percent) and maybe even graph this to show managers. I am trying to show a manager how many courses "meet" the goal and how many "don't meet" the goal.
Any help would be great!