Single Filter with all the Manager Name

sijojoseph22 — Thu, 05 Dec 2019 11:16:14 GMT

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

Re: Single Filter with all the Manager Name

Taoufiq_Zarra — Thu, 05 Dec 2019 14:20:00 GMT

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,

topic Single Filter with all the Manager Name in App Development

Single Filter with all the Manager Name

Re: Single Filter with all the Manager Name