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 ..
Crosstab with Compared year1 / year2 in percent
in Products
Posted
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