Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below records in a table
Name | Department | job |
---|---|---|
Name1 | Dep A | job1 |
Name2 | Dep A | job1 |
Name2 | DepB | Job1 |
Name3 | DepB | job2 |
Name3 | DepB | job2 |
I want group the names based on department,
Names Dep A only, Names Dep B only, Names both departments in three straight tables.
Try the attached
Here what i want is display the Name with is assign only to the Dep A,
So It needs to have only one record (Name1)
Is it possible to do so?
May be like this:
1) {<Name = e({<Department = {'DepB'}>})>}
2) {<Name = e({<Department = {'Dep A'}>})>}
Hi
Please see the attachment
hth
Sasi