Crosstab with Compared year1 / year2 in percent

[marmai]

Hello community,

I have the following problem I have a statistic which compares the sales of two years, I should now show the increase in percentage.

Example:

 

                                                                              2009                     2010             Increase in %

Customer 1                       Product 1                100                          120             +20%

                                             Product2                  80                            100             +25%

                                             Product.....

                     Sum Customer1                           180                          220              +23%

Customer 2

Customer....

The crosstab works perfect, but I have no idea how I can calculate the percentage.
Can someone give me a hint how to solve the problem or how can I use the values of each column in a calculation ..

Thx

Markus

 

Post Edited by marmai at 06/29/2010 05:53

Post Edited by marmai at 06/29/2010 09:10