Need to know how to only show a group that has more than 1 details 1

[Fadius]

I am working on a report and am probably overlooking something really simple, but here is what I am trying to do.

I have a field with names. Another field shows which site(s) they are at.

I need this grouped on each person, but only show those people at more than 1 site while showing which sites these people are at.


Thanks in advance.

 

[lbass]

Insert a group on {table.person} and then go to report->selection formula->GROUP and enter:

distinctcount({table.site},{table.person}) > 1

-LB