Suppress Values so they are not counted in crosstab 1

[kezdawg]

I have a crystal crosstab like this

Symptom A Symtom B TOTAL
No of Males 3 7 10

No of Female 6 1 7

However I would like to both suppress any values in the symptom A and Symptom B column that are less than 3 and minus these values from the total count column.

I know i can conditionally format the fields to suppress them (ie currentfieldvalue < 3) but what I want is to remove them altogether.

Therefore having a table that displaying like this

Symptom A Symtom B TOTAL
No of Males 7 7

No of Female 6 6


Anyone's help is much appreciated

 

[lbass]

This would be simpler as a manual crosstab. Insert a group on gender, and then create formulas like:

//{@A}:
if {table.symptom} = "A" then 1 //repeat for "B"

Insert sums on these two formulas. Then conditionally suppress the summary counts > 3 based on currentfieldvalue. Then use a formula like the following for the Total:

(
if sum({@A},{table.gender}) > 3 then
sum({@A},{table.gender})
) +
(
if sum({@B},{table.gender}) > 3 then
sum({@B},{table.gender})
)

-LB