cancel
Showing results for 
Search instead for 
Did you mean: 

How to find all the workers in a certain area by gender (male/female)

0 Kudos

The information about gender is in infotype 2,

But what if i want to know not only what is in info type 2,

Lets say i want to know how many female workers are working in nyc branch, how do i do that?

Accepted Solutions (0)

Answers (1)

Answers (1)

DellSC
Active Contributor

You have to add the table that contains info about where people are assigned and then "join" that to infotype2 based on a "key" field that is in both tables. In this case, the key might be something like a person ID that identifies the person. You would then either set the selection criteria in the Select Expert to something like this:

{infotype2.gender} = 'F' and {BranchAssignment.Branch} = 'NY'

Or, f you want to see info multiple branches on the same report, but split by branch, you would group by branch and put the person information in the details section.

-Dell