Cross tab report rows

[jak]

Hi Guys,

I am new for Cognos.

Iwould like to get my report in a cross tab in the following.

Year                 Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
___________________________________________________________
Previous year    10   20
Curren year

[manishtirpude]

Hi,
Use the functions to display the current year and previous year.
to_char(current_date,'YYYY')---for current year
to_char(_add_years(current_date,-1),'YYYY')---for previous year.

Thanks