This report shows an analysis of profitability per postcode, although you can replace postcode with any other customer attribute, such as suburb, custom group, customer profile, or customer tag to analyse against that dimension.

It links three tables together (observe the inner join from jobs to invoice cost centres) and filters out jobs with no postcode or where the invoice total is empty. That will ensure that any archived, uninvoiced jobs will not appear in the report. Jobs are filtered to display only archived and invoiced jobs.