![]() |
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