6 Replies Latest reply on May 23, 2016 1:50 PM by Katrina Roque

    Need help with Calculating rate for dimensions

    Katrina Roque

      Hello,

       

      I am wondering if it is possible to calculate the rate of specific dimensions. I basically need to calculate the rate of certain codes in my data and the calculation I'm trying to accomplish is sum(code1)/Sum(all codes)

       

      The problem I'm having is that the codes I have are listed in rows under 1 column vs different columns for each code. 

       

      I've attached my workbook for reference. 

       

      Thank you so much for your help!