7 Replies Latest reply on Jan 22, 2016 7:42 AM by Kent Sloan

    Percentage of Total

    margaret.tanutama

      How do I create the last 2 columns?

       

      NameItems
      Week 1Week 2Total% of Total
      % of Grand Total
      Jane Total4090130=130/130=130/210
      JaneBook2050=70/130=70/210
      Paper2040=60/130=60/210
      Mike Total6050110=110/110=110/210
      MikeComputer4030=70/110=70/210
      Lamp2020=40/110=40/210
      Grand Total90120210=210/210