Multiple columns, one filter

[#1]

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!

[sunny_talwar]

Not really sure I understand how you are planning on viewing this?