0 Replies Latest reply: Dec 25, 2012 10:43 AM by Muhammad Imran RSS

    Peek function to get change in col value

      hi,

       

      i am looking for script which give how many time P_ID is change from green to red in a month..

       

       

       

      My source table look like

      Date                P_ID               Status

      1 jan 2012          1                    Green

      2 jan 2012          1                    Green

      3 jan 2012          1                    RED

      4 jan 2012          1                    Green

      5 jan 2012          1                    Green

      6 jan 2012          1                    RED

      7 jan 2012          1                    RED

      8 jan 2012          1                    RED

      .........

       

      1 Feb 2012          2                    Green

      2 Feb 2012          2                    Green

      3 Feb 2012          2                    RED

      4 Feb 2012          2                    RED

      5 Feb 2012          2                    Green

      6 Feb 2012          2                    Green

      ........

       

      and output which i need look lke

       

       

       

      Month          P_ID          count of Change to Red

      Jan 2012         1               2

      Feb 2012         2              1

       

       

       

      thanks