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

    Percentage of total in series

    Jes Lee

      Hello,

       

      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,

      Jessica