Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,