December 2, 200520 yr Newbies I have a database with three main tables: Reports; Projects: Evaluations. In each report, we evaluate the progress of about 20 projects. Each project is evaluated according to 5 criteria (relevance, efficiency, effectiveness, impact, and sustainability). Each project can be assigned any one of six possible ratings for each of these criteria (-2, -1, 0, +1, +2). For each report, I want to summarise the number and/or value of projects by criterion and by rating. This is a simple matter if I take one criterion at a time. But if I try to summarise all criteria at the same time they are "nested". Is there any way to summarise all criteria at the same time and at the same level so I would get the number of projects rated -2, -1, 0, +1, +2 for relevance, and then listed below this the number of projects rated -2, -1, 0, +1, +2 for efficiency at the same level as relevance, not as a subset of relevance?
Create an account or sign in to comment