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
Thank you for any assistance,
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.
Yes, I am aware of these. The actual table/db is much larger and complex than my simple example.
Maybe. But for the calculation you only need these two columns.