Newbies Evaluator Posted December 2, 2005 Newbies Posted December 2, 2005 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?
Recommended Posts
This topic is 6932 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now