to show 7 days trending, MTD , PMTD columns in Crosstab.

[anoop_sp]

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

[MFGF]

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.

[anoop_sp]

Hi,

we are using an relational package.


Thanks
Anoop

[linbai]

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