Sumif in Pivot Table Query

[mart_mrexcel]

I have a table for Employee promotion and i inserted a pivot table having the total heads for each department. My Query is, How can i add a formula in the pivot to insert a column Promotion YES and Promotion Column and sum the total of YES or NO in each Department.

I tried using "=if([Promote Yes/No]="Yes",sum([Promote Yes/No]),0)" but its an error

(Note: i click the "Add this data to the Data Model" when inserting pivot)

This is the Emp Table					This is the Pivot		This is expected Result	This is expected Result
Employee	Department	Promotion Yes/No			Row Labels	Count of Employee	Promotion YES	Promotion No
Emp1	HR	No			Finance	2	1	1
Emp2	Finance	Yes			HR	2	0	2
Emp3	HR	No			Operation	2	1	1
Emp4	Finance	No			Procurement	1	0	1
Emp5	Procurement	No			Grand Total	7
Emp6	Operation	Yes
Emp7	Operation	No

 

[CA Vijay Gupta]

 

[CA Vijay Gupta]

Kindly Refer the above Image.
Putting
Department in Row Field
Promotion in Column Field
and Employee in Value Field

 

[mart_mrexcel]

Kindly Refer the above Image.
Putting
Department in Row Field
Promotion in Column Field
and Employee in Value Field

hi CY thanks for the response. That works perfect. Have a nice day