@toby-hicks1 have you had a chance to try out the new “Pivot table” functionality on the “All sales” report yet? I believe this should resolve your request for you, but can you please confirm either way?
If you haven’t seen it, here’s the announcement: