Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Hi,
Check the attached file.
HTH
Hi.
See the attached sample for clearity of your solution.
Regards,
Anand
Thanks All!
Bye