Forum Discussion
Moirty
Jan 14, 2019Copper Contributor
Pivot Table % Complete Calculation
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
- Detlef_LewinSilver Contributor
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
- MoirtyCopper Contributor
Yes, I am aware of these. The actual table/db is much larger and complex than my simple example.
-bs
- Detlef_LewinSilver Contributor
Maybe. But for the calculation you only need these two columns.