Yeah, I was trying to avoid that since it would add more complexity on the SQL side. There are currently different grouping criteria that are handled in formulas within the report. Some are based on record count, some are based on actual value, or a sum of values.

If there's a way to do that within the report it would likely be a lot cleaner.