Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 d_petrov
		
			d_petrov
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello,
I can sort the dimension by clicking the header, but how to apply the same behavior to the expressions?
When I click an expression header the numeric values inside are not sorted 😞
For the first dimension I use =AGGR(Id,.....) , for all expressions I use MAX([value])
Any ideas how to sort the expression (Columns Estimate 1 to 5) by clicking them and receive the non-zero values at the top ?
Best Regards,
Drago
 MindaugasBacius
		
			MindaugasBacius
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 d_petrov
		
			d_petrov
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Yes, but how?
Total Estimates is an expression similar to the rest and therefore nothing is sorted by clicking it.
Best regards,
Drago
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Do you happen to have disabled or conditionally hidden expressions in your chart? If you do, can you try to delete them and then try to sort it again?
 d_petrov
		
			d_petrov
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello,
All expressions are enabled, no conditional appearance, or something hidden.
These columns are =MAX(value) grouped by dimension ID
Any other suggestions?
Best Regards,
Drago
