Need help with include/excludes 1

[loveyoursite]

CRV10. I have a report that needs to show employees with more than one position, i.e. Level 1, Level 2, Level 4.
If an employee has more than 1 position, then all of the positions must be listed. I'm not sure how to exclude those employees who have ONLY 1 position. For example:

Include employees with more than 1 position:
J. Brown, Pos Level 1, Painter
J. Brown, Pos Level 2, Contractor
J. Brown, Pos Level 5, Engineer

Exclude employees who have ONLY 1 position, which would always be a Level 1:
B. Green, Pos Level 1, Painter

I would appreciate any assistance. Thanks!

 

[lbass]

Group on {table.employee}, and then go to report->edit selection formula->GROUP and enter:

distinctcount({table.position},{table.employee}) > 1

-LB

 

[loveyoursite]

That worked perfectly. Thanks so much! If you have time, would you mind telling me what that formula is "saying"? I'm not sure I understand.

 

[lbass]

Select this group of employee records if the employee has more than one position."

-LB