Hi Nick,

It's true that a filter isn't 'sticky' - when you select a second filter, the results of the first filter are no longer used.

If you want to have a filter for both category selection AND zero sales suppression, you need to incorporate this into your filter formula with the AND function:

AND ( {Category}="XYZ" , {Sales Qty}<>0 )

From above, this filter would only select items with the category XYZ and at the same time have non-zero sales. Note that there is a comma separating both statements - this is important. What you'd need to do is replace the statements above with the ones you have got working.

Another way to do this is to leave the filter you have for non-zero sales. Then create a second View based on the IC Category list and link it to your current view. Double-clicking from this list is all you need to filter your view additionally by Category code. I mention this way because it will produce the results faster than by a filter alone (where the data has to be re-read with the new query).