Subtotals and filters
 

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?

Subtotals and filters
 

Hi
use

=subtotal(9,your range)

"smartgal" wrote:

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?