Crosstab report : Last three weeks and Last three quarter!!

[koolbachi]

Hi Cognos Folks ,

I have crosstab report in i need to show three weeks and three quarter back which i am getting but the problem is that i need to latest / latestfetch day data in weeks friday data for week and for quarter lastest data.

I had made two queries one for quarter and one for week when i run separetly the data is ok but when i join the data its gives whole week data and adding whole weeks as quarter.

Could you please help!!

thanks in advance.

gops

[kaevne]

Join the two queries into a single one with both sides as an outer join 0..n.  Then specify the combined one as your crosstab.