5 Replies Latest reply on Jul 24, 2018 6:33 PM by Zhouyi Zhang

    Cumulative count over respective years

    iced cuppa

      Given the following data:

      Company Name201620172018

      A

      1410
      B010
      C121
      D202
      E300
      F000

       

      How do i insert a filter such that if i select 1, it will display the following

      Company Name201620172018
      B010
      E300

       

      If i select 2, it will display the following

      Company Name201620172018
      A1410
      D202

       

      If i select 3, it will display the following

      Company Name201620172018
      C121

       

      If i select 0, it will display the last company F.