You need to use the trick of filtering using a table calc - then the filter is not applied to the source, but to the results - therefore totals etc. still work
Replace your [field] filter with a table calc: LOOKUP(ATTR([field]),0)
That could work for you
Thank you I need to try this when I find five minutes.