Using Count If in Pivot Table - Calculated Field

[alvingarcia305]

I would like to count rows of Employees by Group and Division filtered by Item to create a calculated field that check percentage of Tardiness by Group.

something like this on Insert Calculated Field
Name: % of Tardiness in Jan
Formula: =((COUNTIF(Item no,Group = 'Claims')-Jan)/COUNTIF(Item no,Group = 'Claims')


A. Tardiness Table
[TABLE="class: grid, width: 556, align: left"]
<colgroup><col><col><col span="2"><col><col span="3"></colgroup><tbody>[TR]
[TD]Item No[/TD]
[TD]Empl Typ[/TD]
[TD]Group[/TD]
[TD]Division[/TD]
[TD]Employee Name[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]1[/TD]
[TD]Claims[/TD]
[TD]Fin[/TD]
[TD]Charles Dane[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]1[/TD]
[TD]Consumer[/TD]
[TD]Ops[/TD]
[TD]Leonor Fynn[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]103[/TD]
[TD]1[/TD]
[TD]Consumer[/TD]
[TD]Svc[/TD]
[TD]Freah Meghan[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]104[/TD]
[TD]1[/TD]
[TD]HO[/TD]
[TD]Fin[/TD]
[TD]Timmy White[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]105[/TD]
[TD]1[/TD]
[TD]HO[/TD]
[TD]Ops[/TD]
[TD]Russ Dane[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]106[/TD]
[TD]2[/TD]
[TD]Claims[/TD]
[TD]Ops[/TD]
[TD]Rowald Simons[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]107[/TD]
[TD]2[/TD]
[TD]Claims[/TD]
[TD]Ops[/TD]
[TD]Talyor Jones[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]108[/TD]
[TD]2[/TD]
[TD]Claims[/TD]
[TD]Fin[/TD]
[TD]Sam Green[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]1[/TD]
[TD]Claims[/TD]
[TD]Fin[/TD]
[TD]Amy Leong[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]110[/TD]
[TD]2[/TD]
[TD]Claims[/TD]
[TD]Svc[/TD]
[TD]Charles Bruin[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]201[/TD]
[TD]2[/TD]
[TD]HO[/TD]
[TD]Svc[/TD]
[TD]Emily Young[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]202[/TD]
[TD]2[/TD]
[TD]Claims[/TD]
[TD]Ops[/TD]
[TD]Eva Mendez[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]203[/TD]
[TD]2[/TD]
[TD]Consumer[/TD]
[TD]Ops[/TD]
[TD]Katrina Hans[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]204[/TD]
[TD]2[/TD]
[TD]Claims[/TD]
[TD]Fin[/TD]
[TD]Ronnie Arrow[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]205[/TD]
[TD]2[/TD]
[TD]HO[/TD]
[TD]Fin[/TD]
[TD]Celine Leighnor[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]206[/TD]
[TD]2[/TD]
[TD]Claims[/TD]
[TD]Svc[/TD]
[TD]Toby McKinsey[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]207[/TD]
[TD]2[/TD]
[TD]Consumer[/TD]
[TD]Svc[/TD]
[TD]Samuel Ripley[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]208[/TD]
[TD]2[/TD]
[TD]Claims[/TD]
[TD]Svc[/TD]
[TD]Brian Chua[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]209[/TD]
[TD]2[/TD]
[TD]HO[/TD]
[TD]Fin[/TD]
[TD]Tristan Rooney[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]210[/TD]
[TD]2[/TD]
[TD]Claims[/TD]
[TD]Ops[/TD]
[TD]Alvin Bexter[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]