2 Replies Latest reply: Aug 26, 2011 6:20 AM by Lorenzo Gibbo RSS

    Pivot filtered by lowest number

    Lorenzo Gibbo

      I Load from a database a data like this table:

      Code

      Sequence

      Color

      A

      1

      Yellow

      A

      1

      Red

      A

      2

      Blue

      A

      3

      Green

      B

      2

      Red

      B

      3

      Green

      C

      3

      Yellow

       

      I need to display in a pivot only the Code corresponding at the lowest number of sequence, as in the example below:

       

      Code

      Sequence

      Color

      A

      1

      Yellow

      A

      1

      Red

      B

      2

      Red

      C

      3

      Yellow

       

      Do you have any suggestions for a formula set in the pivot which allows me to filter the data in this way?

      Thanks all.