Multiple Nesting Function

Hello Jet Reports Community,
I have hopefully a quick question you might be able to assist with. I created the following report and it is subtotaling by sell-to customer the invoices for the posted period. I would like it subtotal each invoice by customer # VS. ALL the invoices. Basically the format is correct Except I would like the subtotal by each invoice by customer vs. ALL the invoices by customer. This report is pulling all info from the Sales Invoice Line table using 2 NL formulas in B12 & C11. I realize I need another layer of grouping to do this and essentially need to nest another rows statement. I believe I need to increase the row count on the primary replicator, the secondary replicator and add a third for the individual documents. I use to be pretty proficient in JET about 5 years ago and never did that much with the subtotaling groups. If someone could assist me with this last formula I would be eternally grateful! I have attached the report I'm using which is missing the third replicator. (File named: Bill To Sell To Sales by Posting Date EXAMPLE) I have also attached an EXCEL/Non-Jet version of what I would like to look like. (File named: REPORT SHOULD LOOK LIKE THIS)

Thank you!

Jay

• Bill To Sell To Sales By Posting Date EXAMPLE.xlsx
• REPORT SHOULD LOOK LIKE THIS.xlsx