I've traditionally been using what you describe where you choose the department or consolidated from the box at the top of the screen. But I've somehow managed to create a statement that specifies both account and department on each line, so it ignores what is in that selection box. This is helpful in some cases, but I don't know what I did differently.

I've created account groups - that doesn't even give an opportunity to specify department, and I drag and drop them on a new sheet to create the statement. Then there are choices to make such as current balance, or budget amount and it makes different columns for these for each account. Maybe somewhere in here is some that is ticked or not ticked that makes the difference, but I thought maybe someone else would know what and where that choice is. Hope this is clearer.
_________________________
Barb