Show data for rolling 13 months period

[bepanda]

I'm using Cognos 10 BI.
I have a table
Table1: col1 varchar, col2 timestamp, col3 integer
I would like to show a Crosstab of col1 and col3 over a 13 months period, every time I run my report without having to enter the start date.
Any smart way to do this?

[MFGF]

Hi,

Add a filter with the expression:

[Col2] between _add_months (current_timestamp, -13) and current_timestamp

Cheers!

MF.