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

    Need help with Calculating rate for dimensions

    Katrina Roque



      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!