Forum Discussion
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 Ya...
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.