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?
I know how to use set analysis in fields that do calculations (sum, count, etc), but how I can ignore filters in dimensions like customer ID or Customer name? And to be clear, customer field is exactly the field I want to use as a filter in the second table and ignore all other filters.