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





      Thanks in advance.