Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi, how do I sum up the 'inv turnover' (see in attached sample data) for each month and display it as a data point above the grouped bar chart like below? Each bar represents each site(see in attached sample data). Thanks.

 
					
				
		
Hi,
If the Sites are fixed (No change in future), you can use Combo chart and add individual expression for each Sites (Bar) and one expression for Total (Symbol).
Thanks
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Rachel,
I remeber that me and couple of other guys replied to this same requirement from you. Could you get that thread back? The previous discussion could help others to identify the issue properly and help you precisely. To say, a fresh thread is not always good.
 
					
				
		
But if I do that the bars are grouped by site and MonthYear...
 
					
				
		
Hey thanks but unfortunately I can open the qlikview files...
 
					
				
		
 ThornOfCrowns
		
			ThornOfCrowns
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		The other thread mentioned by tresesco is here: http://community.qlik.com/thread/122101
 
					
				
		
 ThornOfCrowns
		
			ThornOfCrowns
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Are you using Personal Edition, or is it another issue preventing you from opening the files?
 
					
				
		
Yeah, I'm using Personal Edition.
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		See the screen shots attached.
 
					
				
		
Hey thanks so much, but I need to be like this (grouped by monthyear):

