cancel
Showing results for 
Search instead for 
Did you mean: 

Subtotal Problem

Former Member
0 Kudos

Please excuse my ignorance, but I am having a lot of trouble getting a subtotal to appear on a report. This report is basically an invoice listing. It sorts first by vendor name and then by invoice number. Each invoice may have multiple lines that go to different GL account codes. I'd like the report to also subtotal by invoice number. I was able to accomplish something similar by adding a new group, but it started making my report sort by invoice number instead of by vendor name. Any help would be appreciated. Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Thanks for your quick reply. I believe that is where my problem lies. I added the third group (to do the subtotals) but then everything wants to sort in invoice number order. As soon as I delete the third group, my report goes back to sorting in Vendor then invoice number order (but without invoice subtotals). Apparently, my beginner knowledge has me messing up somewhere. Thanks!

Former Member
0 Kudos

Why can't you just add the invoice subtotal to the Invoice group footer?

You did not answer Debis question - What was the third group? Seems very strange that Group 3 over rode the Grp1 Vendor.

Ian

Answers (1)

Answers (1)

Former Member
0 Kudos

Check the order of your groups.

Group 1 should be the Vender, and

Group 2 should be the invoice.

What did you group the 3rd group on?

Edited by: DebiHerbert on Jan 5, 2011 4:04 PM