show a group based on sum of a field ?
Posted on 2009-02-13
i am a total beginner to CR.
I am using Version 9
i have Report similar to this format
Customer NO Customer Sales 1 Unit1 Sales2 Unit 2
Product NO Product $56 5 $34 6
so what this is :
its a sales comparable , we are comparing how much a customer ordered last year (sale1,uni1) vs this year
i have created a Group based on Customer NO. and its fine
end of each customer group i am reporting the total for "SALE 2" , now what i need is, i dont want to know about a customer if they didnt place an order this year. so if TOTAL of Sales2 is ZERO i dont wana see them. i dont have the option in Product expert to select i assume since its a Summary insert... any idea?