Print Page - Running _total of yearly Sales and weekly Sales besides each other

Title: Running _total of yearly Sales and weekly Sales besides each other
Post by: barrysaab on 27 Mar 2012 03:11:57 AM

I have requirement to show running_total of yearly total Sales and other column as weekly running_totals besides each other of product where product line=ABC and product type=123.I have created two queries one for yearly running totals and second one weekly running totals and joined them.But my report is showing only weekly sales ignoring yearly running totals.Iam not able to understand where i am going wrong.Please help.Thanks

Title: Re: Running _total of yearly Sales and weekly Sales besides each other
Post by: barrysaab on 27 Mar 2012 03:59:54 AM

Sorry i have failed to mention,It is relational Database and 8.4 version.Thanks

Title: Re: Running _total of yearly Sales and weekly Sales besides each other
Post by: blom0344 on 27 Mar 2012 08:31:26 AM

Hard to imagine the layout of the report in the first place.
Weekly running totals would imply that the data is presented based on weeks (grain = week). How do you plan to work in yearly running totals? (in the same list?)

Title: Re: Running _total of yearly Sales and weekly Sales besides each other
Post by: cogusergirl on 28 Mar 2012 10:55:03 AM

sound like a relative time report

Like

Month - YTD - MAT

or do you actually meaning running total in separate columns

	Week 1	Week 2	Week 3
Prod 1	2	2+3=5	5+3 =8

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: barrysaab on 27 Mar 2012 03:11:57 AM