ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table % Calculation (https://www.excelbanter.com/excel-discussion-misc-queries/207209-pivot-table-%25-calculation.html)

cockatoo

Pivot Table % Calculation
 
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%





All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com