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
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.
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.
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
Unfortunately I have no suggestion for this.
Eduardo