Is there a way to use subtotals where the subtotal ignores filtered
rows but includes the grouped rows? It is interesting that when you
collapse the group the subtotal includes the rows but if you filter
first and then collapse the group the subtotal ignores both the
filtered rows and the grouped rows.

thanks