Have a cross tab report that shows auditor names in the rows and results in the columns. The results are in 3 categories (Fail, Pass, Pass w/comments). These then total per auditor. I need to find the percentage passed (passed includes passed w/comments). I can create the formula to do all of this in the report footer by summming items, but this formula can't be used in the cross tab. Need to be able to show in the crosstab preferably Any ideas are appreciated.
Data showed look like :
Fail Pass Pass w/com Total Perc
Joe 3 6 1 10 70%
Data showed look like :
Fail Pass Pass w/com Total Perc
Joe 3 6 1 10 70%