I suggest to calculate a new field during the load statement in order to have better performance... so:
Count(if(status='Active',fe_ref_num,0)) as CountFeRef,
Sum([Qty sold]) as TotQtySold
group by User;
if(CountFeRef>3 and TotQtySold=0, User) as NewUser
Drop table MainTable_tmp;
and then put NewUser field on your charts !