6 Replies Latest reply: Nov 2, 2016 5:02 PM by Jessica Lee RSS

    Percentage of total in series

    Jessica Lee



      I'm trying to construct sector composition using employment data.   I have a data series for total jobs and one series for each sector.   I would like to compute the composition of each sector (sector weight) and add data to the table.


      Here's  an excel view of what I'm trying to achieve:



      What would be the easiest way to do this?



      Thank you,