9 Replies Latest reply on Dec 23, 2016 7:44 AM by Arun Chandramouli

    Year to Date Turnover % Calculation

    Arun Chandramouli

      Hi All,

       

      Wishing you a Merry Christmas and Happy New Year in advance.... I would like to achieve the turnover % calculation as outlined in the Excel file attached....I have two files ---one which gives me terminations on a monthly basis for couple of years ...another file which gives me a headcount number for the whole company on  a monthly basis...I would like to achieve the following calculation in tableau...For instance if I am looking for  Year to Date turnover percentage number for the month of Nov 2016 then

       

      Sum of Terminations until Nov 2016(12 month period) divided by Average of Headcount for 12 months until Nov 2016...So I should be able to perform such rolling calculations...

       

       

       

      Appreciate your help!