1 Reply Latest reply: Oct 26, 2016 4:24 PM by Sunny Talwar RSS

    Multiple columns, one filter

    Sanford Yee

      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:

       

      RecordKPI1KPI2KPI3
      1QDEC16QDEC16QDEC16
      2QDEC16QMAR17QMAR17
      3QDEC16QDEC16QMAR17
      4QSEP16QDEC16QMAR17

       

       

      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!