Your brother may be a pharmacist John, but you obviously know nothing about the profession, and to decide the occupation of the ~46,000 pharmacists in this country off your brother goes to show your naivity. If you must know...
72% are community pharmacists
22% are hospital pharmacists
8% are Primary Care Pharmacists
10% classed as "other" (Industry/academia/regulatory bodies etc)
The figures add up to more than 100% as if you work in hospital/academia/primary care, you can earn extra money by locumming in community at the weekend.
There is no such thing as a "community pharmacist in hospital". Hospital pharmacists on the whole have a different role.
I've worked in two community pharmacies (for lloyds and boots)
None of the pharmacists working in them go near the bog rolls or whatever else you think they do. They do clinical checks on prescriptions and give advice to people on lots of conditions.
I'd give you some links to go and read up on the subject so you don't look so stupid in future, but your ignorant attitude suggests to me that you wouldn't bother.