Hi,
My search is giving below output,
Month  FieldA    FieldB
Jan         285      1410
Feb         247      1934
Mar         215      2197
Can we create a new column with FieldA% and FieldB%, below is the example
Month  FieldA    FieldB   FieldA% FieldB%
Jan         285      1410        20%           80%      
Feb         247      1934         22%          78%
Mar         215      2197         15%           85%
Eventually i will only be using Month and FieldA% in a column chart
 
					
				
		
 
		
		
		
		
		
	
			
		
		
			
					
		Use eval to compute the percentage
| eval FieldApct = (FieldA*100)/(FieldA + FieldB)
| rename FieldApct as "FieldA%"
