I noted in the forum that savefiles.com have samples of calculation for Pivot
table, but the savefiles is a blocked site at the workplace. Column B to G
are end product of a Pivot Table. SSI work status is a field with 4 options
of data as listed in Col C to Col F. I copied and paste special value to
form the following table and manually created Column H=E3/G3. Is it possible
to calculate the % Complete = E3/G3 using pivot table function?

Col B Col C Col D Col E Col F
Col G Col H
Count of
SSI work status SSI Work Status
Station Not Started InAction Complete Overdue Total %

CapeTown 0 72 3 0
75 47%
Antelope 0 29 22 0
51 4%
Arcogen 0 64 56 0
120 3%
Grand Total 0 165 81 0
246 33%