Visualization below shows the bottom 5 categories (article groups) based on GM, with color based on sales. As shown my sales range runs from 464 to 2,83M.
As customer with low sales are not interesting I would like to filter these out, resulting in a new bottom 5 categories.
When I filter on sales range I run into two problems:
- The range shown in the filter has no relation to the actual sales range. I have no clue how the values shown are calculated.
- When I enter a value in the from value, e.g. 100000, my Bottom 5 is reduced to a Bottom 3. This means the filter is applied after calculating the Bottom 5, but I want to see the Bottom 5 after filtering the categories on sales > 100000 !
Anyone a clue how to solve this?