Hello!
I have a data where I was success in filtering 2 column which do not include zeros, however, I was not able to retrieve the data which is related to those two columns.
This My Table
Table Slicers on Excel Dashboards
I have filtered the first two columns.
Table Slicers on Excel Dashboards
I have used this formula.
First column ( =FILTER(C4:C55,(E4:E55>0)+(F4:F55>0))
Second column (=FILTER(D4:D55,(E4:E55>0)+(F4:F55>0))
Now I need to retrieve the right data related to those two columns from Q1 and Q2
Thank you
I have a data where I was success in filtering 2 column which do not include zeros, however, I was not able to retrieve the data which is related to those two columns.
This My Table
Table Slicers on Excel Dashboards
| DEPT | Column1 | Q1 | Q2 |
| BONE & JOINT CENTER | left without being seen | 0 | 0 |
| BONE & JOINT CENTER | wrong clinic appointment | 0 | 0 |
| BONE & JOINT CENTER | support services - facilities | 0 | 0 |
| BONE & JOINT CENTER | left against medical advice | 0 | 0 |
| HBKMC BUILDING 329 | left without being seen | 0 | 0 |
| HBKMC BUILDING 329 | wrong clinic appointment | 0 | 0 |
| HBKMC BUILDING 329 | support services - facilities | 0 | 0 |
| HBKMC BUILDING 329 | left against medical advice | 0 | 0 |
| INTERNAL MEDICINE CLINIC | left without being seen | 0 | 0 |
| INTERNAL MEDICINE CLINIC | wrong clinic appointment | 0 | 0 |
| INTERNAL MEDICINE CLINIC | support services - facilities | 0 | 0 |
| INTERNAL MEDICINE CLINIC | left against medical advice | 0 | 0 |
| OPD LEVEL 1 | left without being seen | 0 | 1 |
| OPD LEVEL 1 | wrong clinic appointment | 1 | 2 |
| OPD LEVEL 1 | support services - facilities | 3 | 0 |
| OPD LEVEL 1 | left against medical advice | 0 | 0 |
| OPD LEVEL 2 | left without being seen | 8 | 4 |
| OPD LEVEL 2 | wrong clinic appointment | 2 | 1 |
| OPD LEVEL 2 | support services - facilities | 0 | 0 |
| OPD LEVEL 2 | left against medical advice | 0 | 0 |
| OPD LEVEL 3 | left without being seen | 0 | 0 |
| OPD LEVEL 3 | wrong clinic appointment | 0 | 0 |
| OPD LEVEL 3 | support services - facilities | 1 | 0 |
| OPD LEVEL 3 | left against medical advice | 0 | 0 |
| OPD LEVEL 4 | left without being seen | 0 | 0 |
| OPD LEVEL 4 | wrong clinic appointment | 1 | 0 |
| OPD LEVEL 4 | support services - facilities | 0 | 0 |
| OPD LEVEL 4 | left against medical advice | 2 | 1 |
| OUTPATIENT DEPARTMENT | left without being seen | 0 | 0 |
| OUTPATIENT DEPARTMENT | wrong clinic appointment | 0 | 0 |
| OUTPATIENT DEPARTMENT | support services - facilities | 0 | 0 |
| OUTPATIENT DEPARTMENT | left against medical advice | 1 | 0 |
| PEDIATRIC | left without being seen | 1 | 0 |
| PEDIATRIC | wrong clinic appointment | 0 | 0 |
| PEDIATRIC | support services - facilities | 0 | 0 |
| PEDIATRIC | left against medical advice | 0 | 0 |
I have filtered the first two columns.
Table Slicers on Excel Dashboards
| OPD LEVEL 1 | left without being seen |
| OPD LEVEL 1 | wrong clinic appointment |
| OPD LEVEL 1 | support services - facilities |
| OPD LEVEL 2 | left without being seen |
| OPD LEVEL 2 | wrong clinic appointment |
| OPD LEVEL 3 | support services - facilities |
| OPD LEVEL 4 | wrong clinic appointment |
| OPD LEVEL 4 | left against medical advice |
| OUTPATIENT DEPARTMENT | left against medical advice |
| PEDIATRIC | left without being seen |
| QATAR METABOLIC INSTITUTE | left against medical advice |
| SURGICAL SPECIALTY CENTER - OUTPATIENT DEPARTMENT | left without being seen |
| SURGICAL SPECIALTY CENTER - OUTPATIENT DEPARTMENT | support services - facilities |
I have used this formula.
First column ( =FILTER(C4:C55,(E4:E55>0)+(F4:F55>0))
Second column (=FILTER(D4:D55,(E4:E55>0)+(F4:F55>0))
Now I need to retrieve the right data related to those two columns from Q1 and Q2
Thank you
