I run a company that sends qualified leads to hardware distributors.
Someone gets in touch with us via our site, and pass on their information to four distributors (out of several dozen, we pick the four best ones).
Every week, we invoice each distributor for the number of leads we’ve sent them.
So the records for a given week might look something like this
What I want to be able to produce, is a view that shows how many leads each distributor had, and how much they owe.
So from this view above, it should return:
Complete Vending Services | 2 Leads | £100
Full House Coffee | 1 Lead | £50
Esprada | 1 Lead | £50
Underdog Coffee Company | 2 Leads | £0
Caffia Coffee Group | 1 Lead | £0
GMS ESpresso Ltd | 1 Lead | £0