I'm still fairly new to CRXI so any help will be appreciated.

I am trying to created a report that looks something similar to this:

Customer         Item Description       QTY     Unit Cost    Amount
--------         ----------------            ----         -------------      ---------
Cust1                    Clear Bottles                    100         0.50               50.00
                             Tax                                   50.00      .0875             4.38
                             Shipping Charge              1              6.75               6.75
                                                                                                          ---------
Cust1 Total                                                                                         61.13

Cust2                    Dark Bottles                    100         0.60                60.00
                             Tax                                   60.00      .0875             5.25
                             Shipping Charge              1              6.75               6.75
                                                                                                           ---------
Cust2 Total                                                                                         72.00


I can put all the record fields but I can't seem to calculate the SUM correctly. I'm curious if there is a better way to go about this.

Thank you.