Running Query
 

I am attaching to an external database using ODBC to populate a Pivot table.
The external database store the sales information. It has the customer
number, date of Invoice, Order number, product number, line number on the
Invoice, quantity, cost, selling price and the total margin on the entire
Invoice. As you can see the total margin is repeated in every line until the
next customer information. I am trying to extract the total margin less than
certain dollar value and use the pivot table to create a report by customer
and date or Invoice number. What is the formula I need to use to extract the
total margin?

Thanks for the help.
Krish