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

Item No	Empl Typ	Group	Division	Employee Name	Jan	Feb	Mar
101	1	Claims	Fin	Charles Dane	1	1	2
102	1	Consumer	Ops	Leonor Fynn	1	2	1
103	1	Consumer	Svc	Freah Meghan	1	4	1
104	1	HO	Fin	Timmy White	3	2	2
105	1	HO	Ops	Russ Dane	1	1	1
106	2	Claims	Ops	Rowald Simons	1	3	2
107	2	Claims	Ops	Talyor Jones	2	1	1
108	2	Claims	Fin	Sam Green	1	2	1
109	1	Claims	Fin	Amy Leong	1	1	1
110	2	Claims	Svc	Charles Bruin	2	1	2
201	2	HO	Svc	Emily Young	1	12	2
202	2	Claims	Ops	Eva Mendez	1	1	2
203	2	Consumer	Ops	Katrina Hans	1	3	1
204	2	Claims	Fin	Ronnie Arrow	1	1	3
205	2	HO	Fin	Celine Leighnor	2	1	2
206	2	Claims	Svc	Toby McKinsey	1	4	1
207	2	Consumer	Svc	Samuel Ripley	2	1	1
208	2	Claims	Svc	Brian Chua	3	2	1
209	2	HO	Fin	Tristan Rooney	1	1	1
210	2	Claims	Ops	Alvin Bexter	3	1	1

<colgroup><col><col><col span="2"><col><col span="3"></colgroup><tbody>
</tbody>