I have a SQL query in the Data environment that joins 3 tables and I have grouping on some fields. I have designed a report that uses this DE command object with the grouping and it all works fine.

However I would like to add another level of grouping based on another field. I know how to add a new group to the report but how do I add another level of grouping to the command object containing the SQL query?

Help would be very much appreciated.