Hi everybody,
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.
Thanks.