Last 3 Months with Data

[Chamopak]

Hi,

I do not know if this question has been asked already.
but I am trying to have a report to automatically show the last 3 months with data.

For example:

Set Month:
Jan    Feb     Mar     Apr        May     Jun
12      342   65        89          43


Then I only need to display:
    Mar     Apr        May
   65        89          43

Can anyone help?
TM1 is the backend database.

[BigChris]

No idea about the TM1 aspect...is that an OLAP source, or is it relational? Either way, you're going to need to take into account the year as well, otherwise the report is going to fall over in January.