Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

How To Show Year-to-Year Growth Percentage in a Crosstab


#1

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