Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: anoop_sp on 26 Sep 2014 03:48:24 AM

Title: to show 7 days trending, MTD , PMTD columns in Crosstab.
Post by: anoop_sp on 26 Sep 2014 03:48:24 AM
Hi ,

I have a requirement to show 7 days trending date and MTD  columns in crosstab. When i try to filter last 7 days trending data, MTD doesnt work.

Could anybody please help me out on this?   :)

Thanks,
Anoop
Title: Re: to show 7 days trending, MTD , PMTD columns in Crosstab.
Post by: MFGF on 30 Sep 2014 06:50:41 AM
Quote from: anoop_sp on 26 Sep 2014 03:48:24 AM
Hi ,

I have a requirement to show 7 days trending date and MTD  columns in crosstab. When i try to filter last 7 days trending data, MTD doesnt work.

Could anybody please help me out on this?   :)

Thanks,
Anoop

What type of package are you reporting off - relational or dimensional?

MF.
Title: Re: to show 7 days trending, MTD , PMTD columns in Crosstab.
Post by: anoop_sp on 06 Oct 2014 02:08:09 AM
Hi,

we are using an relational package.


Thanks
Anoop
Title: Re: to show 7 days trending, MTD , PMTD columns in Crosstab.
Post by: linbai on 06 Oct 2014 09:00:48 PM
use 3 query to show 7 days trending, MTD , PMTD, then join the 3 query as one query(query 4).  make crosstab with query 4 
Text only | Text with Images