Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 srinivasuluraju
		
			srinivasuluraju
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi All,
I need your help,how to create pivot table in Qlik sense like as below.i want to display ' May 18' as main category,under this have to display subs,% ,Cv as Sub Category and calculated subs ,%,Cv values.
Thanks in advance!
 shiveshsingh
		
			shiveshsingh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You should use the month year column as dimension(which is showing May18), and then drag it to upper row.
And use these as expressions - subs,% ,Cv .
You'll get the desired output.
 srinivasuluraju
		
			srinivasuluraju
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks for your quick response.That is working well,but i want to display Above arrow value as separate Column like as image.
 shiveshsingh
		
			shiveshsingh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		which one is the arrow value?
 srinivasuluraju
		
			srinivasuluraju
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		That one calculated value like(Sum(Sales)).On Right hand edge Symbol in that image.
