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
Highlighted
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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 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