Guys I am almost embarrassed to ask this question

I got a pivot table and a field called Supervisor which is a yes or no and then I got another column call district 1 district 2 and district 3

I am trying to show the number of supervisors not number of people in each district.

So I need to create a calculated field which counts the # of Yeses under supervisor correct?

Well I can not get it right.

This is what I tried IIf([Supervisor]=True,1,0)

however this didnt work.

Matt