I'm having some trouble trying to cross a table. I have a dimension called year where for each year I'm summing some values. Now I need to compare among these years a percentual growth. My idea is to make a cross table, like the following:
Ano
2010
2011
2012
2010
0%
-5%
-2%
2011
10%
0%
12%
2012
15%
-15%
0%
I've tried duplicating the year dimension by creating year2 and crossing these dimensions, but no success.
If anybody could give me a clue of how I can solve this, I'd be really glad.
