3 Replies Latest reply: Sep 6, 2017 5:14 AM by jagan mohan rao appala RSS

    Cross Table  - Date Logic

    RAM MUTHIAH M

      I have data with several dates and want to show like below.

       

      Sample input data and output given below

       

      Input :

       

      PN

      CN

      Date

      Value

      1

      A

      4/9/2017

      1

      1

      A

      5/9/2017

      1. 1.5

      1

      B

      5/9/2017

      1. 1.5

      1

      B

      6/9/2017

      1. 1.6

      1

      B

      7/9/2017

      1. 1.55

      2

      A

      4/9/2017

      1

      2

      B

      3/9/2017

      1. 1.25

      2

      B

      5/9/2017

      1. 1.25

      2

      C

      4/9/2017

      1

      2

      C

      5/9/2017

      1. 1.5

       

      Should be like :

      Output Cross Table.JPG