Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor II
Partner - Contributor II

Worst Category in dynamic text

Hi can someone please assist me.

I'm trying to find the worst selling category using the Rank function in a text object.

I have already done the best selling category using the following :

='The best selling category is: ' & chr(13) & chr(13) & FirstSortedValue(Category,-aggr(sum(Sales),Category))

The following are the categories ordered according to their sales totals


10 Replies
Specialist II
Specialist II

The explanation is we are trying to sort the category in ascending order with the below expression


pipe is the seperator used, so we are using an index to find the first part which is the first part of ascending


But pls use the First sorted value solution provided by tresesco, bec this might consume more ram than first sorted value.