I have a report that successfully shows the degree of success of specific Performance Measures with the use of a color coded, “Status”. Status is the result of a Query “Build”, calculating the input data against the desired Target: “Red”: More that 10% below target, “Yellow” within 10% of Target, “Green”, At or Exceeds Target.
There is a series of similar reports for each category of the Dept.
Now, the user wants me to include on these same reports–probably on the footer, the % of the total record list for the given Dept that are “Green”.
For example, for one Dept, there are a total of 17 records, and of those, 5 are “Green”.
Consequently, on the footer of this particular report, it should read: 29.4% are “Green”.
I need to know the most efficient use of Query(s) to allow this note to be put on the Report.