This content has been marked as final. Show 5 replies
I have two tables in my sheet. First table is as follows:
CustID Total Product count
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?