Subtotals and filters

[smartgal]

I have a report with two levels of subtotals. Typically if I filter on any
criteria, I continue to get the Grand Total row. However, on my report today
when I filter, I only get the criteria that matches, no total row. How can I
update this so that I get the total row, even when filtering?

 

[Eduardo]

Hi
use

=subtotal(9,your range)