Thanks Andrew. I used that report just as an example for explanation purposes as report that will automatically include new departments as the are added. It does give the departmental summary totals but I need to build a report that will give me account level detail sorted by department without need to hard code each individual department. Essentially a report that goes department to account level detail per department with sum total. We use this report to breakdown costing on individual Capital projects. Each project gets its own department. So a side by side comparison isn't that useful, but a "snapshot" that includes account level details for all active departments separately would be. Can it be done or should I build the sheet by manually including departments as they become active? I have tried different combination of .range .rangedept and the accountgroup and accountgroupdept formulas but can't seem to get to the sweetspot that I am looking for.