current year total vs past year totals (1 Viewer)

gilescis

D. Castaldo
Local time
Today, 02:05
Joined
Jan 23, 2006
Messages
106
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
 

Users who are viewing this thread

Top Bottom