A client has asked if it is possible to create a report that includes some rows lkke the following:

Department Name one
Account 5000
Account 5001
Account 6000
Account 6001
Etc.
Subtotal
Department Name two
Account 5000
Account 5001
Account 6000
Account 6001
Etc.
Subtotal
. . . and so on.

I know I can do this by adding the department number to the ranges in the account tree (or in the range definition in the spreadsheet for that matter). However, that means that the report template(s) must be edited when a new departmenr is added.

I wonder if anyone has found a way to make this more of a "smart" system.