I'm having brain freeze on the best way to do this.
I have a crosstab report listing routes as it's rows and giving a count of people on those routes as it's columns.
Fairly simple yes?
What i need it to do is count how many of those people were on that route per year for the last 5 years.
The people need to be counted for all the years they are on the route, not just the year they start.
Year isn't a field that i can use (i will have to create a formula) but i do have route start and end date
what i need the report to look like is
03/04 04/05 05/06 06/07 07/08 08/09
route1 xxx xxx xxx xxx xxx xxx
route2 xxx xxx xxx xxx xxx xxx
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"
I have a crosstab report listing routes as it's rows and giving a count of people on those routes as it's columns.
Fairly simple yes?
What i need it to do is count how many of those people were on that route per year for the last 5 years.
The people need to be counted for all the years they are on the route, not just the year they start.
Year isn't a field that i can use (i will have to create a formula) but i do have route start and end date
what i need the report to look like is
03/04 04/05 05/06 06/07 07/08 08/09
route1 xxx xxx xxx xxx xxx xxx
route2 xxx xxx xxx xxx xxx xxx
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"