Forum Discussion

Moirty's avatar
Moirty
Copper Contributor
Jan 14, 2019

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_Lewin's avatar
    Detlef_Lewin
    Silver 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

     

    • Moirty's avatar
      Moirty
      Copper Contributor

      Yes, I am aware of these. The actual table/db is much larger and complex than my simple example.

      -bs

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor

        Maybe. But for the calculation you only need these two columns.

         

Resources