If you make a Summary field for dollar total from company and sort by company, that should give you a report of the dollar total for company per customer/client.
Thank you for the quick reply, please forgive my newness but the problem I have is when I create the summary field I only have the customer fields available not the prices from the line items.
Base your report layout on LineItems. Define the summary fields there and add fields from Customer to either the header or a sub summary part "when sorted by customer". THen add a subsummary part when sorted by company.
Perform a find to pull up the records for the customer or customer that you want and then sort the records by the same fields you specifed as "sorted by" in the sub summary parts.
If you'd like to read a tutorial on how you might do this: Creating Filemaker Pro summary reports--Tutorial
Phil and David,
Thank you both so much, once I drew records from the correct table (duh!) it worked like a charm and the summaries were perfect.
Thank you again so much