Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stacked bar chart - additional sum

Status
Not open for further replies.

sardine53

Programmer
Jul 4, 2003
79
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top