How to retrieve records that has multiple record

[n1ef5ng1]

Hi guys,

I have assigned a primary key ID for individual customer. My table dimension will be Cust_ID, Date_of_Visit with an expression of sum(Revenue)

For my table, I would want to show all those customer who visited more than one time in Date_of_Visit field

How can i do it?

I would want to eliminate records that has only one record for date of visit with one cust ID

[n1ef5ng1]

My date of visit is a date field/

[tresesco]

May be like this?

Calculated dimension: =If(Aggr(Count(CustID), date_of_Visit)>1,CustID)