How to total by Invoice #?

[Rochelle_505]

Hello Everyone,

Does anyone know how to add a calculation field that will add up the item totals by invoice#? I have a sub-summary that has a grand total at the end of the report, but my boss wants to see the total of each individual invoice also.

Sub summary Grand total looks like this:

=Total of item total

Not great with all the formulas someone please give some advice? Thank you thank you!!!

[Keith LaMarre]

It sounds like you want a total of your "line items" by invoice number - you should probably make a table called Invoices that can have multiple line items - this file would then have your Invoice total field which would equal SUM(related line items).

without that, you have to have your report do all of the work - you would only be able to show your existing field when the report is sorted by invoice number and you would make a part to display that field when invoice number changes.