Home

Pivot Table % Complete Calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-314539%22%20slang%3D%22en-US%22%3EPivot%20Table%20%25%20Complete%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314539%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20appreciate%20help%20on%20creating%20a%20pivot%20table%20calculation%20that%20delivers%20the%20percentage%20complete%20from%20a%20list%20of%20dates.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH4%20id%3D%22toc-hId-1281230883%22%20id%3D%22toc-hId-1425356913%22%3ESimplified%20Example%20Table%3A%3C%2FH4%3E%3CP%3EJob%2C%20Date%20Done%3C%2FP%3E%3CP%3EClean%20House%2C%201%2F12%2F19%3C%2FP%3E%3CP%3EClean%20Yard%2C%20%5Bblank%5D%3C%2FP%3E%3CP%3EClean%20Attic%2C%201%2F14%2F19%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH4%20id%3D%22toc-hId--1270926078%22%20id%3D%22toc-hId--1126800048%22%3EDesired%20Pivot%20Table%20Output%3A%3C%2FH4%3E%3CP%3E%23Tasks%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%25Completed%3C%2FP%3E%3CP%3E3%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%2067%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20assistance%2C%3C%2FP%3E%3CP%3E-bs%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-314539%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314739%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20%25%20Complete%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314739%22%20slang%3D%22en-US%22%3E%3CP%3EMaybe.%20But%20for%20the%20calculation%20you%20only%20need%20these%20two%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314699%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20%25%20Complete%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314699%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20I%20am%20aware%20of%20these.%20The%20actual%20table%2Fdb%20is%20much%20larger%20and%20complex%20than%20my%20simple%20example.%3C%2FP%3E%3CP%3E-bs%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314640%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20%25%20Complete%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314640%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20a%20pivot%20table%20with%20a%20calculated%20field%20but%20it%20spit%20out%20100%25.%3C%2FP%3E%3CP%3EOn%20the%20other%20hand%20you%20really%20do%20not%20need%20a%20pivot%20table%20for%20this.%3C%2FP%3E%3CP%3EIn%20E2%3A%3C%2FP%3E%3CPRE%3E%3DCOUNTA(tbl_Jobs%5BJob%5D)%3C%2FPRE%3E%3CP%3EIn%20F2%3A%3C%2FP%3E%3CPRE%3E%3DCOUNT(tbl_Jobs%5BDate%20done%5D)%2FE2%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Bruce Sohn
New Contributor

I would appreciate help on creating a pivot table calculation that delivers the percentage complete from a list of dates.

 

Simplified Example Table:

Job, Date Done

Clean House, 1/12/19

Clean Yard, [blank]

Clean Attic, 1/14/19

 

Desired Pivot Table Output:

#Tasks       %Completed

3                67%

 

Thank you for any assistance,

-bs

3 Replies

Hello

 

I tried a pivot table with a calculated field but it spit out 100%.

On the other hand you really do not need a pivot table for this.

In E2:

=COUNTA(tbl_Jobs[Job])

In F2:

=COUNT(tbl_Jobs[Date done])/E2

 

Yes, I am aware of these. The actual table/db is much larger and complex than my simple example.

-bs

Maybe. But for the calculation you only need these two columns.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies