in Crystal reports XI, I am trying to create the following report:

Group by customer

sum revenue for each customer based on an attribute of the order:

if order has attribute 'a' only, if order has attribute 'b' only or if order has
both attributes 'a' & 'b'.

For the customer group level totals I am all set.

I'm having trouble with getting the report totals for the case where the order has both attribute 'a' and 'b' only.  No matter what I've tried I keep getting the total for the case where attribute 'a' or 'b' is present, which is essentially all records.

do you define an order being in one of these categories by a single row of data or multiple rows of data

it would be a single row; short version for customer record would be something like:

customerid, order#, attribute A, cost
customerid, order#, attribute B, cost

the customer may have one or the other or both, but when the customer does have both they would always be two separate records as shown above.


for the customer totals I created a running total for the customer group where only the A attribute was present, and a running total for the customers with only the b attribute.

Then to get total for customers with both attributes I created a formula that totaled only when both of the other two scenarios above where > 0 because in the combined column I only want the revenue total where the customer has both A & B.  Not sure if this was the best way to go about it, but it did give me the results I needed at the customer group level.

I now have a report footer total for orders with A only, and one for orders with B only, but the same logic I used above wont work.