Set Analysis to Group Records

[anuradhaa]

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.

[sunny_talwar]

Try the attached

[anuradhaa]

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?

[sunny_talwar · Accepted solution]

May be like this:

1) {<Name = e({<Department = {'DepB'}>})>}

2) {<Name = e({<Department = {'Dep A'}>})>}

[sasiparupudi1]

Hi

Please see the attachment

hth

Sasi