0 Replies Latest reply on Sep 18, 2014 11:26 PM by Avia Makky

    Aggregation

    Avia Makky

      Hi All,

       

      I am trying to aggr my KPI "Total number of EMP per Quarter".

       

      For example: In case an employee1 has joined me on 01/01/2005 and still the employee is active in my company and when I take a count of Active employee for 30th June 2014, I would want to have entry for employee1 counted in every quarter right from Q1 2005 to Q2 2014

       

      Please find the data in the attached xl