Show Last YTD column

[dmanoma]

Hi,

Created a cross tab which groups by current year month and the summary gives the current YTD value.Now would like to add a column with LastYTD.Is that possible to do in crosstab?

Eg:
2008- YTD |2007-YTD| jan 08| feb08| ....
Air

Would like to know how to add 2007-YTD column.Any Help is really appreciated.

Thanks
Mano

 

[lbass]

You could add the date as column #1->group options->print on change of year, and then add a second column on a formula:

if year({table.date}) = year(currentdate) then
{table.date}

Then go to group options and choose "print on change of month."

This will however, leave a blank column for last year, in addition to the total. As an alternative, you could create two crosstabs, one based on year, and one based on the above formula, and then overlay one over the other, eliminating unnecessary grid lines and suppressing totals in the month crosstab.

-LB