Pivot filter based on the lowest number

[lorenzo_gibbo]

Load from a database a data table like this:

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.

[#2]

Hi Lorenzo - Try the attached

Loaded Table then laoded Min(Seq) in a resident load then in table only displayed those where seq=min (seq)

[#3]

Hi,

Check the attached file.

HTH

[its_anandrjs]

Hi.

See the attached sample for clearity of your solution.

Regards,

Anand

[lorenzo_gibbo]

Thanks All!

Bye