Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
How can I do this? My brain is having difficulty.
Thanks!
Not really sure I understand how you are planning on viewing this?