CODEWITHSUNDEEP
crystal-reports
IJ76
IJ76

Reputation: 29

Display only records exceeding four items

My Group Footer shows the number of distinct items bought by each customer: 

Cust Ref,      Items bought (distinct count)

001,            4
002,           12
003,           6 
004,           3

How can I display only the customers who have bought 5 or more distinct items? I tried using distinctcount(items bought) > 4 but it looks at all the distinct items bought by everyone, not each individual customer. What formula should I use and where?

Upvotes: 1

Views: 54

Answers (2)

Zeina
Zeina

Reputation: 1603

You have to place a group by CustRef, then at the footer place the CustRef and a formula named @DistCnt containing (DistinctCount({ItemsBoughts})) (It seems you've already done that)!

Then in the Section Expert section click on the (x-2) button near the suppress checkbox related to this group footer and write: @DistCnt < 5 and save.

Upvotes: 1

Siva
Siva

Reputation: 9101

Go to section Expert and then go to suppress write the below code and save

Cust ref <5

Upvotes: 0

Related Questions