Calculations/Summary Status Reports

[jbrigham]

For the life of me, I can't seem to get my head around how to apply calculations/summary fields to get the results I need in this database. I am attaching a sample database in which records are created to represent art requests. Each request is associated with a Grade and a chapter and has a certain "spec type" (or "art type") and status. Given this, I want to create a report that shows, for example, what percentage of each "spec type" is in each status stage (values of the Status field) broken down by grade level. I've included a mock report in the database.

Can anyone help, or point me in the right direction?

Thank you.

Simple_Status_Summary.fp5.zip