I have a report that needs to show total for current year and a total from previous year side by side.
My field is incnumb and i will do a distinct count on that field to give me a total count of each incident number.
Here is sort of what i am trying to make it look like
2012 2011
Type March YTD | March YTD
EMS 200 620 185 640
FIRE 45 92 35 102
Any help is greatly appreciated
My field is incnumb and i will do a distinct count on that field to give me a total count of each incident number.
Here is sort of what i am trying to make it look like
2012 2011
Type March YTD | March YTD
EMS 200 620 185 640
FIRE 45 92 35 102
Any help is greatly appreciated