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.
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.