5 Replies Latest reply: Feb 25, 2016 7:32 AM by yashdeep chauhan RSS

    Ageing of employees according to Month

    yashdeep chauhan

      Hi everyone,

       

      I have Following Data.

      Fields=Emp Code,Month(Month in which Employee won't be having any Project)

      Emp codeMonth
      1Jan 2015
      2Jan 2015
      2Feb 2015
      3Feb 2015
      2Mar 2015
      3Mar 2015
      4Mar 2015

       

      I want Report in below format:

       

      • This report should give the number  of months the employee is on bench.
      •     I have to take two dimensions

                 1.Ageing= No. of months in which he is not having any project

                 2.Month= Count of Employees not having project in That Month

      • I have to take count of Employees

       

      Month
        (Ageing)
      Mar-15Feb-15Jan-15
      1112
      211
      31

       

       

      Thanks in advance.