5 Replies Latest reply: Jun 18, 2018 1:01 AM by Tommi Riekki RSS

    How to ignore filter in a table?

    Tommi Riekki

      I have two tables in my sheet. First table is as follows:

      CustID      Total Product count

      Totals        17

      1                2

      2                4

      3                3

      4                2

      5                1

      6                5


      And the second table shows data only, if I have one CustID selected(done by add-ons GetSelectedCount). This table shows products from selected customer:

      CustID      Product        Product count

      3               Hammer       2

      3               Saw              1


      I also have a filter to filter different products to count total number of different products in the first table. How can I ignore this filter in the second table so that it always shows all the products of chosen customer?