2 Replies Latest reply on Oct 22, 2018 6:46 PM by mac lai

    To calculate percent for each content on the bar

    mac lai

      Hi All,

       

      I would like to know any formula i can use to auto display the % of each Reason  in "Sheet 2" that translate into the total Sale % of the period on "Sheet 1", example

      my Period 18-42 Sale % is 2.34%

      then Sheet 2 on bar 18-42 will have

      • Low Quality = 3/32 * 2.34 = 0.22%
      • Not Nice = 1/32 * 2.34% = 0.07%
      • Not Popular = 13/32 * 2.34% = 0.95%
      • Others = 9/32 * 2.34% = 0.66%
      • Rotten = 5/32 * 2.34% = 0.37%
      • Too Expensive = 1/32 * 2.34% = 0.07%

       

      Added all the total = 2.34% for 18-42.

      Thanks.