I have a page with 4 filters. Year, Period, Category and Customer.
When I filter by a specific category, my customer filter results are limited to just the selected category so total categories is 100 and customers is 100,000. If I select 1 category my customer goes from 100 to 10 (expected). The first table shows count of customers and sales $ when filtered this is 10, customers $20,000 in sales. I want a second table that shows for those 10 customers, what are the sales for all of the 100 categories which I would expect to be customer count 10 and sales for those 10 customers of all categories $50,000 dollars since taking in account all 100 categories.
My issue is I can't get just the 10 customers, it does all 100 customers. Any thoughts why it doesn't keep the customer filter? If i go and indivisually select each customer then it filters by that, but if I leave blank even though the filter shows 10 customers, it does all 100 customers.
