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