Summary
This video looks at how to filter based on slicer buttons.
Tab in example file: Using slicer.
This video introduces the SUBTOTAL function to return 1 if a cell is visible or 0 if a cell is not visible.
SUBTOTAL – Returns the subtotal of a range based on visible cells.
=SUBTOTAL(function_num, ref1, [ref2], …)- function_num – The calculation to perform
- ref1 – Range of cells to calculate
- [ref2] – Second range of cells
- … – On-going ranges of cells
Slicers filter tables by hiding rows which do not meet the slicer selections.
To identify if row is visible, add column to the table which contains =SUBTOTAL(3,[@columnName]