Yes I want it to show for each item. Here is what I have:

2 formulas to pull the 10wk sales and 3wk prev year sales:

IF {@Date Diff} IN 0 TO 69
THEN {SRW68 Transactions.Quantity sold}
ELSE 0
and
IF {@Date Diff} IN 344 TO 365
THEN {SRW68 Transactions.Quantity sold}
ELSE 0
*** I have subtotals on those 2 formulas

from there I took the subtotals and created 2 more formulas:
'10WK - 40PERCENT' (({@10wk}/10)*.4)
'3WK - 60PERCENT' (({@3wk/3)*.6)

From that I did a formula to calculate the Weekly Sales Forecast:
{@10WK - 40PERCENT}+{@3WK - 60PERCENT}

I cannot subtotal this formula (Crystal will not let me do this?)

Maybe I am over-thinking the process to get the answer I need??