Help with Filtering


We have four regions. In each region we have various categories of items.  We are looking at the total quantity of units sold per region. We do not have the category as part of the visualisation.  We want to have a filter (data limiting, etc) that lets the user choose a quantity range based on the total category quantity.  

So with my four regions I'd apply a filter that could remove all the categories with a very low quantity or a very high quantity. We'd want to allow a range (so far doing this with a min and a max). 

We'd want this filter to respect filters in our filtering scheme


So far we cannot make this work. Is there a way to filter in this manner?

(1) Answer