I'm trying to build a cross tab that includes a percentage of total early and on time deliveries in the last field. For example:

       Early    Ontime    Late   Total   OTD%
A        1             1        1       3        66%
B
C
Total

OTD% would be early plus on time, divided by the total. I can't figure out how to make this work. Is there no way for this to work in a cross tab?

Edited by bigburb - 04 Mar 2010 at 7:30am

nevermind, I wound up building a subreport.