2 Replies Latest reply on Apr 24, 2018 3:28 AM by Bill Olander

    creating calculated field from  pivot

    Bill Olander

      Hey all,

      I've searched high and low and pulled out hair for a problem that hopefully is an easy thing for you. 

      So using this sample workbook, I want to create a table which  looks like this:

      CountryPlannedActual% completed
      A10022%
      B5024%
      C10055%

       

      So first I pivoted the Planned and Actual Columns and group by country to create a table with

      Country
      Planned
      Actual
      A1002
      B502
      C1005

       

      Can any generous soul show me how to  create a calculated field "%completed"  which is actual / planned