Skip to Content
0
Jun 22, 2009 at 07:03 PM

Sort order help for date string in crosstab

576 Views

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