Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
orangebloss
Contributor III
Contributor III

KPI Chart Expression - Duplicate first sorted value

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]))

Labels (3)
2 Replies
mruehl
Partner - Specialist
Partner - Specialist

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

should work I think.

Chanty4u
MVP
MVP

Try this

Concat(   DISTINCT

    Aggr(    Only([Product Name]),

        Sum([Order Quantity])    ),   

', ')