COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: naveen10046 on 02 Dec 2010 10:29:21 AM

Title: I need to show data in my crosstab for last 30 days
Post by: naveen10046 on 02 Dec 2010 10:29:21 AM
I need to show data in my crosstab for last 30 days

I have MTD and Last month
As of now-
MTD has 02/12/2010, 01/12/2010
Last month has 1/11/2010, 2/11/2010...to....30/11/2010

I have nested  [MTD] next to [Last Month]

Now I have a column as shown below

| 02/12/2010  | 01/12/2010 | 1/11/2010 | 2/11/2010 |...to....| 30/11/2010

But I need to restrict it to show only for last 30 days.
How could I accomplish this.

Thanks in Advance
Naveen ;D
Title: Re: I need to show data in my crosstab for last 30 days
Post by: MFGF on 02 Dec 2010 03:51:08 PM
Are you using a relational package or a dimensional package?  The solution for each will be different.

MF.