Pivot Table % Complete Calculation

Copper 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.