4 Replies Latest reply on Nov 10, 2016 7:57 PM by Sherzodbek Ibragimov

    Share calculation when total is mentioned in the same column

    Muzamil Shafeek

      Hi,

       

      I have a table as

       

      CategorySale
      a

      20

      b12
      c15
      Total

      47

       

      What i want to derive is the % of Share as shown below

      CategorySaleShare
      a2042.55%
      b1225.53%
      c1531.92%
      Total47100%

       

      The "Total" number may or may not match with the sum of others, when the % is more we have to fix it at 100%

       

      Please help