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]

Not sure I understand the output you are looking to get. Would you be able to elaborate on the kind of output you need?

UPDATE: May be this:

Straight Table A uses

{<Department = {'Dep A'}>}

Straight Table B uses

{<Department = {'DepB'}>}

Straight Table C uses no set analysis or

{<Department = {'Dep A', 'DepB}>}

[anuradhaa]

In Tables 1

Name only DEp A

-------------------------------

Name1

In Tables 2

Names only DEP B

--------------------------------

Name2

In Tables3

Names both Deps

-----------------------------

Name3

[sunny_talwar]

What is the expression you are using? Add the set analysis I have provided above for each of the table

[anuradhaa]

I needs Name and job in Straight Table.

Where should i put that set analysis expression?

[anuradhaa]

I dn't want to do any calculations. i need a table with Name and Job

[sunny_talwar]

I guess you can add Name as your dimension and following expressions:

1) Only({<Department = {'Dep A'}>} job)

2) Only({<Department = {'DepB'}>} job)

3) Only({<Department = {'Dep A', 'DeptB}>} job)

[Kushal_Chawda]

Just create single the Table like below, I am not sure why you need 3 tables here

Dimension:

Name

Department

Job

Expression:

Your Expression

Simply create the list box for Department and select the Department you want and see the result in Single straight table instead of 3 tables

[Anonymous]

Hi Anuradha,

For Dept A:

Aggr(MaxString({<Name = {$(=Count({<Department = {'Dep A'}>} Name)>0)}>} Name),Name)

For Dept B:

Aggr(MaxString({<Name = {$(=Count({<Department = {'Dep A'}>} Name)>0)}>} Name),Name)

For Both:

Aggr(MaxString({<Name = {$(=Count({<Department = {'Dep A','Dep B'}>} Name)>0)}>} Name),Name)

Kind Regards,

[anuradhaa]

it's not working, can you please share a sample