I have a list for 24500 tickets sales. Each sale has a customer number which relates to the customer who bought it.

A customer may have bought more than one ticket and there will be a record for each ticket sale.

What I need to find out is how to filter or create a new view where I can see the customers who have only purchased once.

The best way I have thought of is to find a way to filter the view so that I only see customer numbers that have just one record but I can't see a way to filter this or create a new view using deluge.

Using distinct(Customer_Number) doesn't work as all the customer numbers are unique and they may have purchased more than once.

What I need to be able to say in script/filter is:

"If the customer number only appears in the view once then show it."

Any suggestions would be great....

Thanks

Jon