Does my attached work for you?
This is using a simple boolean calculation with both an aggregation and a window aggregation scoped to the sub-category level.
I am altering the colours here isntead of filtering so you can see how it would work if you moved the calculation to a filter.
Play with each of the parameters, see if it works for you.
Appreciate your patience of going through such long questions and coming with attached workbook.
The workbook that you shared partly answers my question. So the calculation 1 (a boolean) that you created includes the category/subcategory based on sales punched into the parameters.
The exclusion part is still not there (as i understand). So lets say you have 4 sales parameters two for inclusion and two exclusion.
And once you enter values in inclusion parameters it should include data that meets the criteria and once you enter the sales in exclusion parameters so it should exclude the data which meets the criteria.
I hope i did not end up confusing you.