how to use the countif or sumif formula in pivot table in 2013

[sivaprakasam]

Hi, try to formula in pivot in calculated fields

how to use the countif or sumif formula in pivot table in 2013

IF(COUNTIFS($A$2:A2,A2,$C$2:C2,C2,$L$2:L2,">0",$M$2:M2,0,$A$2:A2,A2)>1,0,1)

 

[vletm]

sivaprakasam
... etc ...
a) Are You sure that You'll need countif nor sumif with Pivot-table?
b) Next c/would give an answer https://www.contextures.com/excel-pivot-table-calculated-field.html