1 Reply Latest reply: Feb 29, 2016 11:53 AM by Stefan Wühl RSS

    How to count new id enter and existing id removed from table

    Silambarasan M

      Input Table:

      Id   date

      1.   1-jan-16

      2.    1-jan-16

      1.     2-jan-16

      2.     2-jan-16

      3.     2-jan-16

      1.      3-jan-16

      3.      3-jan-16

      3.      4-jan-16

      4.      4-jan-16

       

       

       

      Expected result:

      Using pivot table count ID based on date .

      Eg. Day one :  id-1,2 are enter. So count of ID is 2

             Day two : id-3 alone enter . so count of new ID is 1

              Day three record id-2 alone removed and no other new id enter.so,count of removed ID is 1


      Day four: new id -4 enter.so it is new ID.count is 1


      Note: count if new ID enter.

                 Count if id removed.



      Month.   Day.   1.    2.     3.        4

      Jan.                   2.    1.      1        1