I've written this quickly as an example, I'll try to put a proper example together shortly.

select

'Fred Bloggs' as Name,

'Sky Hooks' as Sector,

8005.23 as TotalTurnover

UNION

Select

'Fred Bloggs',

'Pith Helmets',

8005.23

UNION

Select

'Fred Bloggs',

'Unicycles',

8005.23

UNION

Select

'Brenda Bloggs',

'Sky Hooks',

11005.56

UNION

Select

'Brenda Bloggs',

'Unicycles',

11005.56

UNION

Select

'Brenda Bloggs',

'Bable Fish',

11005.56

The parameter selected by the report user is Sector

Display Name and ToalTurnover, grouped by Name, filter by Sector.

So, Select Sky Hooks and Unicycles, the report looks like this:

Fred Bloggs 8005.23

Brenda Bloggs11005.56

But the total will be 38021.58