are you looking for a patient count threshhold, a percentage threshhold or a patients with asthma (count) threshold?
using your example you have something like:
Code:
Provider AsthmaCt PatCt PctAsthma
Prov1 3 6 50%
Prov2 1 4 25%
What is your desired end result
To show both of the providers but only show a percentage if they are above a certain level? something like (assuming your threshhold is 30% asthma patients):
Code:
Provider AsthmaCt PatCt PctAsthma
Prov1 3 6 50%
Prov2 1 4
or to only show providers who meet a certain threshold (again assuming a 30% threshold)
Code:
Provider AsthmaCt PatCt PctAsthma
Prov1 3 6 50%