Crosstab report and two date ranges

rutuja

Hi,

I am trying to generate a crosstab, which has a layout similar to this.
First row shows the months and the second year and previous year for the specified month range.
I am not sure how to do this. Can you please help?

Layout


Jan Feb .....etc

Jan 2008 | Jan 2007 |Feb 2008 | Feb 2007 | ........etc...

A's sales
B's sales
C's Sales
...etc...
Thanks, Rutuja

mwilliams

Hi Rutuja,

If you make computed columns of year and month off of your date field, you can reverse the order of the year and month in the crosstab dimension. Then you can use descended sorting on the year dimension to get them to order backwards.

Hope this helps.