Hi Anyone:
I'm trying to make a manual cross tab to show for each business line GH1
TP
CS
LAB
And then for each month (always 3 previous months), I want to show total # of tickets for each GH1
December January February
# Percent # Percent # Percent
TP 29 15% 30 25% 82 25%
CS 55 85% 70 75% 95 75%
Total 84 100% 100 100% 177 100%
I also have to be able to find 1st 2nd and 3rd month. The report runs every month which gets data for 3 previous months. Does anyone know how to do this/
Thank you
Jocelyne
I'm trying to make a manual cross tab to show for each business line GH1
TP
CS
LAB
And then for each month (always 3 previous months), I want to show total # of tickets for each GH1
December January February
# Percent # Percent # Percent
TP 29 15% 30 25% 82 25%
CS 55 85% 70 75% 95 75%
Total 84 100% 100 100% 177 100%
I also have to be able to find 1st 2nd and 3rd month. The report runs every month which gets data for 3 previous months. Does anyone know how to do this/
Thank you
Jocelyne