0 Replies Latest reply: Nov 16, 2017 5:01 AM by Soniya Narayani RSS

    Bucket Movement Of Values

    Soniya Narayani

      Hi Guys,

       

      I have a case where my IDs for the month are with respect to a bucket.

      Find attached data for reference.

      I need to count as follows:

      -- Bifurcation of Buckets:

           a) New IDs moved in the month from previous

           b) Same IDs in the same Bucket

      For example:In January i have 4 ids in 1-30 bucket and from 4 how many have moved to 31-60 bucket in the month of february and from 61-90 how many have moved to March bucket.In same way if for the month of february 5 are in 1-30 bucket and from that how many have moved to march month in 31-60 buckets