Hi All,
I have 3 columns that displays what qtr a KPI is in. I want to use one key filter to display all data that belongs to the filtered qtr. This is what my data looks like:
| Record | KPI1 | KPI2 | KPI3 |
|---|
| 1 | QDEC16 | QDEC16 | QDEC16 |
| 2 | QDEC16 | QMAR17 | QMAR17 |
| 3 | QDEC16 | QDEC16 | QMAR17 |
| 4 | QSEP16 | QDEC16 | QMAR17 |
If I filter by KPI3 data of QDEC16, I only want to see the following records:
- KPI1 - Record 1,2,3
- KPI2 - Record 1,3,4
- KPI3 - Record 1
How can I do this? My brain is having difficulty.
Thanks!
