Hello, I'm modifying my last questi

[CrystalBox]

Hello, I'm modifying my last question ("Stacked Bar Char")I submitted on the 26th of this month. I'm using Crystal 11, Access is my Database. I created a stacked bar chart based on the "Protected Groups" Age, Ancestry, Color, Disability etc. Each group bar shows two number values, the top value is the total cases and the bottom value is the number of cases of the total that are what I call "A" cases. Here's an example of what the first three bars look like:

Age: 50(total)\10("A" cases)
Ancestry: 36(total)\8("A" cases)
Color: 77(total)\18("A" cases)

The problem occurs when the first group in the chart, the "Age" group, has no "A" cases; I get the follow result instead:

Age: 50(total)\40("A" cases)
Ancestry: 36(total)\28("A" cases)
Color: 77(total)\59("A" cases)

I'm using a data field and a formula under the "Chart Expert" "Data" tab, "On change of":
{EXP_INITIAL_PROT_GRP.INIT_PROT_GRP_DESC} and If{EXP_CLASSIFICATION.CLASSIFICATION}="A" and {EXP_CLASSIFICATION.DATE}=maximum ({EXP_CLASSIFICATION.DATE},{EXP_CLASSIFICATION.CL_INTAKE})
Then "A" Else "Total Cases"

Thank you