Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I have a small chart where I'm comparing expressions year over year. Currently I have the dimension as the year. Then i have 3 expressions. I have set the table to display horizontally, so that the dimensions are column headers and the expressions are rows.
What I want to do is show the Expression labels in between the 2 years being compared... so the prior year calculations appear on the left of the expression labels and the current year appears on the right. I think i've seen this before but I can't find it again and I'm not even sure how to search for it. So here's what I have:
| 2013 | 2014 | |
|---|---|---|
| Expression 1 | 65465165 | 65874984 | 
| Expression 2 | 54698548 | 68447488 | 
| Expression 3 | 56465841 | 56468546 | 
And here's what I'm trying to get:
| 2013 | 2014 | |
|---|---|---|
| 65465165 | Expression 1 | 65874984 | 
| 54698548 | Expression 2 | 68447488 | 
| 56465841 | Expression 3 | 56468546 | 
Can anyone help guide me?
Thanks
 
					
				
		
 eduardo_sommer
		
			eduardo_sommer
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Just drag the expression column to the left of the dimension column
Eduardo
 
					
				
		
I can't drag the columns, and i think it might be because i have the presentation set to horizontal? The only thing i can move is the year dimension header up and down between the expression rows.
 
					
				
		
 eduardo_sommer
		
			eduardo_sommer
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Ashley,
I think that with Horizontal selected you could not do what you want. Dragging can only be done between dimensions and expressions columns, If you use horizontal the dragging will be vertical.
Eduardo
 
					
				
		
OK, do you have another suggestion to get to what i'm looking for? I'm only using the horizontal orientation right now because it's the closest I could get to what I'm looking for.
 
					
				
		
 crusader_
		
			crusader_
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello Ashley,
How many columns do you have?
If only two, you can use vertical orientation with 2 expressions defined by different set analysis.
HTH
Andrei
 
					
				
		
 eduardo_sommer
		
			eduardo_sommer
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Unfortunately I have no suggestion for this.
Eduardo
