You can specify to retrieve only 1 Item for each distinct value based on 1 column or all columns
Notice that you can use the Sort option below, so that the distinct
value chosen is based on the sort order.
This is useful when the sorted columns have multiple values for each distinct primary value.
You can then get for example the lowest or highest value based on the sort order.
Need more help with this?
DON'T HESITATE TO CONTACT US HERE ..