Yes, this can be done.  This is how I would do it:

1)  In your dataset, add 2 Fields (it will prompt you if they are calculated fields or query fields - choose calculated) - call them ResponseYes or ResponseNo (or whatever you want to name them).  These will be used to store a 0 or 1 depending on the response, so that they can be added up to get the total number of responses.
2)  Under Field Source, click on the formula button and use this formula for ResponseYes:
     =IIf(Fields!TobaccoUseInLast30Days.Value="Yes",1,0)
3)  Under Field Source, click on the formula button and use this formula for ResponseNo:
     =IIf(Fields!TobaccoUseInLast30Days.Value="No",1,0)
4)  In your tablix, group by location, then in the group total, you can use the Sum function to add up the counts (I'm assuming your group name is Location if you are grouping by Location):
=Sum(Fields!ResponseYes.Value,"Location")
=Sum(Fields!ResponseNo.Value,"Location")

That should do it - hope that gives you what you need.