1 Reply Latest reply on Oct 19, 2018 11:21 PM by Shinichiro Murakami

    Finding percentage of total on Column with multiple values seperated by commas

    Yasser Akhtar

      I have some columns in my Excel data which have multiple values separated by commas. I want to be able to find % of total for each item but since some rows have multiple values I can't get the correct percentage.

       

      I tried splitting each value into it's own column but there are too many values. Is there a dynamic solution where I can get 5 of total for each value?

       

      Fruits.JPG