Alright, so, i have a cross tab report.
it's counting the total number of people each department has seen.
and also how many days that department was open in the given month.
Now, i need a 3rd row to state the Avg # of Persons seen in that month.
In a normal report. This is really simple. devide the two sums and
whoah-lah! But, i'm trying to figure out how to do this in a cross tab.
If i try to do it with a formula like
#of persons seen total/days
it gives me an answer for the entire report, not for that specific month/dept.
any ideas?
IP Logged
