23 Replies Latest reply: May 11, 2016 2:25 PM by Stefan Wühl RSS

    How to count entered and removed id based on date?

    Silambarasan M

      How to count entered and removed id based on date?

       

       

      Input table

       

       

      Id.      Date

      1        1-jan

      2.       1-jan

      1.       2-jan

      2.       2-jan

      3.       2-jan

      1.       3-jan

      3.       3-jan

      3.       4-jan

      5        4-jan

      2        5-jan

       

       

       

       

      Expected output

       

      Using pivot table count number of new ID  enter everyday and number of existing ID remove everyday

       

      Note:

       

       

      1.   if same day one new ID enter and existing ID remove then display count value as 1-1.

       

       

      2.  Eg.  Id-2 enter on 1st jan and removed on 4th jan. and again it(ID-2)  enter on 5th jan, so id-2 consider as new id

       

      Month.     Day.   1.     2.      3.        4      5

       

      Jan.                   2      1       1       1-1      1

       

      hicswuehljohnwgwassenaar

       

      Message was edited by: Silambarasan M