KPI Chart Expression - Duplicate first sorted value

[orangebloss]

I'm looking to return the highest number items, the problem I'm having is when I have items with the same number total.

E.g.  

Book A 50

Book B 50

Book C 20

The following expression returns nothing - is there a way for it to return more than one result where there are duplicates?

FirstSortedValue([Product Name], -Aggr(Sum([Order Quantity]), [Product Name]))

[mruehl]

FirstSortedValue(DISTINCT [Product Name], -Aggr(Sum([Order Quantity]), [Product Name]))

should work I think.

[Chanty4u]

Try this

Concat(   DISTINCT

    Aggr(    Only([Product Name]),

        Sum([Order Quantity])    ),   

', ')