Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi,
I have been trying to sort my 'Others' field in my chart as the last bar, but I haven't been able to do it in any way. Could anyone help me?
Greetings,
Lucas
 Nicole-Smith
		
			Nicole-Smith
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Have a look at the Sort tabs on each of the charts in the attached. I've added a sort by expression that sorts the Others value as last. The expressions looks like this:
=aggr(count(Customer),[SLS Organization])
where the dimension for the aggr() function is the dimension on the corresponding chart.
 
					
				
		
As far as I am aware, the others bar automatically sorts as the last one. Are you applying some other type of sorting and still want the 'others' to appear last? If so, please upload a sample and I will have a look at it for you
Cheers,
Byron
 
					
				
		
Hi Byron,
I am not using any type of sorting. I even tried removing the sorting properties in the document settings, but it still shows at a random position in the chart.
Greetings,
Lucas
 Nicole-Smith
		
			Nicole-Smith
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Have a look at the Sort tabs on each of the charts in the attached. I've added a sort by expression that sorts the Others value as last. The expressions looks like this:
=aggr(count(Customer),[SLS Organization])
where the dimension for the aggr() function is the dimension on the corresponding chart.
 
					
				
		
That worked! Thanks!
