Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi guys
If I was to put the Supplier Name and Spend columns from the attached into a straight table, how would I show AFC Ajax on one row, and all the others added together on another?
Thanks in advance,
Gareth
 
					
				
		
 effinty2112
		
			effinty2112
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Gareth,
Use a calculated dimension:
=Aggr(If([Supplier Name] = 'AFC Ajax',[Supplier Name],'Other'),[Supplier Name])
to get:
| Supplier Name | Sum ([Spend (£)]) | 
|---|---|
| £3602388.42 | |
| Other | £3524562.42 | 
| AFC Ajax | £77826.00 | 
Cheers
Andrew
 
					
				
		
 effinty2112
		
			effinty2112
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Gareth,
Use a calculated dimension:
=Aggr(If([Supplier Name] = 'AFC Ajax',[Supplier Name],'Other'),[Supplier Name])
to get:
| Supplier Name | Sum ([Spend (£)]) | 
|---|---|
| £3602388.42 | |
| Other | £3524562.42 | 
| AFC Ajax | £77826.00 | 
Cheers
Andrew
 
					
				
		
Hi Andrew,
That's brilliant - thanks very much.
Cheers
Gareth
 
					
				
		
 effinty2112
		
			effinty2112
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Gareth,
You're very welcome!
Cheers
Andrew
