Re: Slicers in Excel

Another approach is to create a helper column that returns a 1 for a visible record and 0 for a hidden record

= SUBTOTAL(2, [@ID])

The totals are returned by 

= SUMIFS(Table1[2021 Revenue], Table1[Filter], 1)

or
= Table1[[#Totals],[2021 Revenue]]

where the Table Totals row has the formula
= Table1[[#Totals],[2021 Revenue]]

The summary financial data requires one or more formulas and should not itself be a table.  Something else that is possible using 365 is to return a column of filtered values on another sheet using

= FILTER(HSTACK(Table1[ID], Table1[2021 Revenue]), Table1[Filter])