Summary Report Formatting

When you said you wanted to make a summary report with just two or three levels of grouping in fact I guess you need to summarize based on a whole bunch of text fields.

The only way to do that is to do sorting and grouping on those individual text and yes that is limited to just six levels of grouping.

If the report was just for human consumption, then one technique is to concatenate a bunch of those fields together into one giant field and do grouping on that.  But in your use case you're looking to have a CSV output.

One option is for us to work together for about an hour or so to set up a master table as a parent which would have the key feel being the unique combination of fields that you're looking for. Then we would create a few automations which would maintain that parent table so you could make a clean export from there of your CSV file.