Running _total of yearly Sales and weekly Sales besides each other

[barrysaab]

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

[barrysaab]

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

[blom0344]

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?)

[cogusergirl]

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