Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ BI Tools and Applications _ Show Only With 2 Or More Records

Posted by: jimmy0305 Aug 1 2016, 04:18 PM

Hi everyone,

How can I filter records that only has 2 or more IDs?

Every member has member class or group such as (Gold, Silver, Bronze, etc..)
In detail section, each member has visit ID # every time that person comes in.

I have created a distinct count of the visit id (in footer) of each member.

How can I only include or show only those with 2 or more visits per member class?

Many thanks in advance.


Posted by: jimmy0305 Aug 1 2016, 06:24 PM

Or Can I use the Top N Records and only select records with 2 or more visit IDs?