Forum Discussion
Slicers in Excel
I have financial data in an Excel spreadsheet. I've created slicers for certain columns and a table adjacent to the slicers to display total financial figures for two years. My question is: If I writ...
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])