I have a chart that shows the year over year comparison of 2004 vs 2005.
Using Crystal 8.5 with Access 2002
Stacked Bar Chart inserted in GH#1. 2005 is the top part of the bar.
Group 1: Product
Group 2: Companies (using 3 selected Companies + Others)
Group 3: Year (2005 and 2004)
Product 1
2005 1006 985 639 1436
2004 756 563 411 947
Co.A Co.B Co.C Others
33% 75% 55% 52%
Product 2
2005 409 196 93 1002
2004 539 212 133 2170
Co.A Co.B Co.C Others
-24% -08% -30% -54%
Everything is perfect but I need an additional % of lost business for each Company, for each Product. The formula I need is the 2005-2004/2004. I have shown the expected results.
Any help would be appreciated.
Thanks,
Jackie
Using Crystal 8.5 with Access 2002
Stacked Bar Chart inserted in GH#1. 2005 is the top part of the bar.
Group 1: Product
Group 2: Companies (using 3 selected Companies + Others)
Group 3: Year (2005 and 2004)
Product 1
2005 1006 985 639 1436
2004 756 563 411 947
Co.A Co.B Co.C Others
33% 75% 55% 52%
Product 2
2005 409 196 93 1002
2004 539 212 133 2170
Co.A Co.B Co.C Others
-24% -08% -30% -54%
Everything is perfect but I need an additional % of lost business for each Company, for each Product. The formula I need is the 2005-2004/2004. I have shown the expected results.
Any help would be appreciated.
Thanks,
Jackie