Hello everyone,
I am facing a challenge when I try to have the Report studio to calculate and show the year-to-year growth % in a crosstab.
I have created a crosstab to display the sales revenue dollars for year & country in a crosstab.
Crosstab #1 (Year in Column; Country in Row; Sales Revenue as value)
| 2010 | 2011 | 2012 |
Canada | 100 | 103 | 98 |
USA | 102 | 99 | 102 |
Now, I would like to create a second crosstab to display the year-to-year growth percentage (equation: [<Year 2> - <Year 1>]/<Year 1> x 100%) in the following setup:
| 2010 to 2011 | 2011 to 2012 |
Canada | 3% | -4.9% |
USA | -2.9% | 3.0% |
So far, I have failed to create such result with several attempts and hope you could lend me a hand. Thank you so much.
Cheers,
Michael