Problem with Subtotals in Groups

[AcctSolver]

How should I go about this?

Data is structured like this:

Last_Yrs_Sls Customer Order# Order_Amt
$25000 ABCD 1212 $ 2500
$25000 ABCD 1213 $ 2000

I am grouping on customer, and entering a subtotal for the group for order amount. I want to be able to show last year's sales in the total, but only once. I've tried various formulas to suppress the "extra" data, but have not been successful.

Output should look like:
Last_Yrs_Sls Customer Order# Order_Amt
$25000 ABCD $ 4500

 

[synapsevampire]

Place the last_yrs_sls field in the Group footer without doing any aggregate functions. It will show thew last value in the group only (in other words, only one time).

-k