Build a matrix report in Explore

A matrix turns one long grouped list into a grid, which is far easier to compare across periods.

1. Open Explore and choose Orders as the source.
2. Keep the mode on Summary (group and aggregate).
3. Under Group by, add two fields — for example Channel and Order month.
4. Under Metrics, add Sum of Total price.
5. Set the layout to Matrix. The second field becomes the columns.
6. Click Run.

Each row is a channel, each column a month, with a total column at the end. Toggle Show chart to see the same data as bars, then Save so it appears under Custom reports.

Keep going