Hi All -

I'm new here and have learned so much by searching the forums! I can't find the exact answer to a question and hope you can help...

I have a report that summarizes sales by salesman (each salesman being a group). The top level is a list of customers by salesman with running totals for each customer. You can drill down on each customer and see actual invoice details. There are some duplicated invoice lines that are hidden and not included in the running totals.

I would like to put a summary field on the top level that gives the salesman a grand total for all of their customers. It seems really simple, but I don't know what I'm missing here. I can do an actual summary line of the field OEP70.LVAL70 and place it on the top level, but that adds in the duplicated invoices which I'm trying to avoid.

Any ideas?

Thank you,

Karen

Another option would be to create a formula that uses the logic from the "Evaluate" section of your running total.  It would look something like this:

You both have given me some good ideas. I'll let you know how it works out. Thanks.