3 Replies Latest reply on Feb 26, 2016 8:44 AM by Kirti Morker

    Percentage of Total from another field

    Kirti Morker

      I have several columns such as ACV, Lift Kits, Diesel (header names) with value of 1 or 0. I am looking to do percentage of table calculation for each of this columns by summing up each column individually divide into the total count from the different field. (not the total from individual column). The result should look like this when I bring it over to worksheet.

       

                          count          %

      ACV               98          1.8%

      Lift Kits          20           0.8%

      Diesel           10          0.2%

       

      I can create a individual worksheet for each column but I need all columns to show up on a same worksheet.