Hmmn, that sort of works, but what I'm after is this results wise:

doctorname doctorlocation drugname packsize count Total Drugs Prescribed

Campbell Manchester Aspirin 10 1

Campbell Manchester Bisoprolol 10 1

Campbell Manchester 2

Where the 'total drugs prescribed' column is a sum of the count column.