Single Filter with all the Manager Name

[sijojoseph22]

Hi All,

We are having the data in the below sample format

Manager1	Manager2	Manager3	Manager4	Manager5	Manager6
John	Arun	John	Praveen	Praveen	Praveen
John	Arun	John	Lohit	Jack	Jill
John	Arun	Lijo	Nijo	Mat	Mathew
John	Arun	Lijo	Nijo	Mat	Mathew
John	Bilu	Tijo	Deepak	Deepak	Deep
John	Bilu	Tijo	Deepak	Deepak	Deep
John	Bilu	Tijo	Anju	Anju	Anju
John	Bilu	Libu	Rohit	Sean	Tom
John	Bilu	Libu	Sabu	Sean	Tom

We are using 6 filters as below

Filter1	Manager1
Filter2	Manager2
Filter3	Manager3
Filter4	Manager4
Filter5	Manager5
Filter6	Manager6

Is there any way we can create a single filter with all the values.

Manager

John

Arun

Bilu

Lijo

Tijo

Libu

Praveen

Lohit

Nijo

Deepak

Anju

Rohit

Sabu

Jack

Mat

Sean

Jill

Mathew

Deep

Tom

Thanks,

Sijo

[Taoufiq_Zarra]

Hi,

I suggest you use a CrossTable :

Load Script:

CrossTable(ManagerFlag, Manager,1)

LOAD AutoNumber(RowNo(),1000) as RowNo,* INLINE [
    Manager1, Manager2, Manager3, Manager4, Manager5, Manager6
    John, Arun, John, Praveen, Praveen, Praveen
    John, Arun, John, Lohit, Jack, Jill
    John, Arun, Lijo, Nijo, Mat, Mathew
    John, Arun, Lijo, Nijo, Mat, Mathew
    John, Bilu, Tijo, Deepak, Deepak, Deep
    John, Bilu, Tijo, Deepak, Deepak, Deep
    John, Bilu, Tijo, Anju, Anju, Anju
    John, Bilu, Libu, Rohit, Sean, Tom
    John, Bilu, Libu, Sabu, Sean, Tom
];

with this you will have the possibility to make two filters: [All manager],[Flag Manager]

Regards,