Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 bimala0507
		
			bimala0507
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Experts:
In one of chart, I have Year and Month as Dimension and Count ( Sales Order Number) as expression. I would like to show all Year and Months. Currently, if there is no Sales Order for a month, the month doesn't appear. I would like to have Month and value as 0. Tried possible ways of Showing All Values in Dimensions and Disable Suppress missing value in Presentation, but still not able to achieve. Basically I would like to have all Months and Year to be displayed with value 0 or actual value. Can anyone throw some idea on this?
Ex:
Year Month No. of Orders
2003 Jan 0
2003 Feb 10
2003 Mar 8
....
2003 Dec 3
Currently Month Jan is not appearing since, No. of Orders is 0
Kind Regards,
Bimala
 ashfaq_haseeb
		
			ashfaq_haseeb
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Go to chart properties Dimension tab --> Select your Dimension and check show all values.
Now go to presentation tab and deselect suppress zero values.
Let me know if that worked.
Regards
ASHFAQ
 
					
				
		
 sat_tok52
		
			sat_tok52
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi ,
Use This Formula
=Num(Count ( Sales Order Number) +0.001),0.00)
you can able to see zero value on your chart.
