A Custom Event List Report is great for this! You are able to add revenue category columns and it gives you the ability to group by Spaces when exported.

If you export the report to HTML or PDF & choose to 'include summary' you'll see revenue summaries & grand totals on the exported data 😁