Report Grouping - group the columns!


The Report grouping option offers selections by Month and Product but the resulting data is not grouped at all.

The chart becomes a mess of boxes and lines.

What I wanted I had to produce via an Excel pivot table, but it’s a simple table showing

Product quantity totals by month by client.

The filter allows selection per client but the grouping is basically non existent. I know you can click the column headers to do grouping on one column but you can’t also get the sub-group at the same time.

The grouping selector fields at the top of report are therefore doing nothing.

I have screen shots if you don’t get it.

You may want to export the raw data to analyze it.