Anyone know how to default the matrix column on a custom report to "Week"? Currently it defaults to "Total" and I really need it to be "Week" for a scheduled report distribution.

When you customize the report, under the Edit Columns, normally, you'd see the View Columns By. That should be the default. But I'm not sure if it works the same if emailed.

Thank you! This is the setting I was looking for. Unfortunately, it does not appear to be an option on my report, I suspect because it is not a Financial Report?

use these column fields in this order to get close to your outcome