I have a report pulling from a query that list a customer's total freight for each line item on an invoice. I want to list the customer's invoice freight only once per each invoice during the month. Then sum the freight for the month and show percentage of freight spent during the month's purchases. My problem is the report pulls the entire invoice's freight for each item. Here's an example.
Inv. Date Invoice No. Part No. Qty Unit Price Ext Price Freight
12/19/2014 23114555 30101 10 $8.82 $88.20 $17.50
12/19/2014 23114555 41154 5 $17.11 $85.55 $17.50
12/19/2014 23114555 40573 5 $11.69 $58.45 $17.50
$232.20 $52.50
The freight total needs to read only $17.50 since it is the invoice's total freight amount.
I hope I'm explaining this well enough to make sense. Any suggestions?