Export Summary Report - SubSummary only

[hal9000]

I have a report layout that does exactly what I want. See pictures. (The Total Sales field is a summary field.)

BUT, when I export this report from Preview Mode, it looks nothing like the Preview. I've tried tinkering with sorting and grouping, to no avail. Exporting to Excel gets me a little bit closer.

There must be a way to export precisely what is shown in the preview, no?

[comment]

Exporting has very little to do with Preview mode - you export data, not its presentation. Still, I think that exporting while grouped by the same breakfield as the one used for your sub-summary part should produce the desired result.