I created a Cross Sell report - for every Fuel Customer we sell Lubes to - I need to count the customer in that Group and use the number in a formula for our score card.
In Crystal Reports - I have a field for Lube Sales -I want to count any of the Lube sales in GF3 if the total is not 0. I need to have the Count in GF2 to use in a formula. I have tried several formulas and running totals and it is not working.
Can you help? I attached a screen shot of the report.