Well I am not even sure if this can be done. I have a mock crosstab that currently looks like this:
Service 1 Service 2 Service 3
Completed
Opened
Average
This is in the Report Header and is based on summaries of formula's. I have the same thing mock crosstab in the Group header which is grouped on agents.
For the Average I am trying to divide the Completed for each service by the number of Agents that had something completed for that service. For instance there are 74 orders completed for Service 1 and 11 total agents but only 4 of them did Service 1 work. The average should be 18.5 (74 / 4). I can get this in the footer using a running total but I need it in the header. I have tried using variables but they also do not work in the header. Does anyone have any idea if this can even be done?
Thanks
Service 1 Service 2 Service 3
Completed
Opened
Average
This is in the Report Header and is based on summaries of formula's. I have the same thing mock crosstab in the Group header which is grouped on agents.
For the Average I am trying to divide the Completed for each service by the number of Agents that had something completed for that service. For instance there are 74 orders completed for Service 1 and 11 total agents but only 4 of them did Service 1 work. The average should be 18.5 (74 / 4). I can get this in the footer using a running total but I need it in the header. I have tried using variables but they also do not work in the header. Does anyone have any idea if this can even be done?
Thanks