Jan 14 2019 05:37 AM
I would appreciate help on creating a pivot table calculation that delivers the percentage complete from a list of dates.
Job, Date Done
Clean House, 1/12/19
Clean Yard, [blank]
Clean Attic, 1/14/19
#Tasks %Completed
3 67%
Thank you for any assistance,
-bs
Jan 14 2019 08:02 AM
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
Jan 14 2019 09:36 AM
Yes, I am aware of these. The actual table/db is much larger and complex than my simple example.
-bs
Jan 14 2019 10:19 AM
Maybe. But for the calculation you only need these two columns.