function in Pivot table

[leibale]

Its seems to be very simple question, but I cannot solve it
I have a table with 2 columns: Dapartment, YesNo. the YesNo column have value of 0 for NO and 1 for Yes
Now, I want to use Pivot table to get this result:
Department Yes No
to do it I created a new calculated field within the Pivot Table: if(Yesno=1,0,1)
but the sum of the new field is not good
where is my mistake? I must it inside the pivot. I know I can do it without the pivot table)
thanks

 

[SamS]

removed

 

[SamS]

Leibale, do you want to reverse the values in your Yes/No column

 

[leibale]

yes,
I want 2 columns : first to sum the values of YesNo column so I know how many Yes are, then I want to sum the calculated field in which 1 is 0, and 0 is 1, and get how many No are for each department
thanks

 

[SamS]

Leibale, what your formula is doing is calculating on the result of your pivot table, I do not know how to do this other than creating another column with your formula.