5 Replies Latest reply on Mar 12, 2017 12:03 PM by Deepak Rai

    I have unioned data and need a calculated field

    alex lewis

      Please help......

       

      I have unioned two work sheets, one with the number of staff on Temporary Promotion (TP) and the other with the total number of staff;

       

      HR  150                    TP HR  30

      Finance 40               TP Finance 15

       

      I want to show the number of staff on TP by area in a bar chart with a label showing the percentage of the workforce.

       

      I presume I am going to need a calculated field, however, I am awful at these, anyone have any ideas?