Hello All,
I need to calculate the number of calls for service for the last 13 months. Display the number in the report footer by month and year in a grid similar to a crosstab and in ascending date sort order.
Example:
May 2008 1,400
Jun 2008 1,287
Jul 2008 1,290
all months through last full month
May 2009 1,385
I can calculate the number of calls per month and display the month and year by converting the month and year to text. However, I cannot seem to find a way to sort the month and year without some kind of on-going manual intervention. I need to make the report maintenance free for monthly scheduled e-mail distribution in business objects enterprise. Specified order does not work since the column headers will change each month. It needs a sort order formula, but I am not sure how can this be done inside a cross tab?
Any help or suggestions are appreciated!
Thanks,
Wendy Douglass