Excel tables, a total row and slicers provide a quick way to filter a dataset and see a result for the rows that remain visible. This approach is useful for Excel users who need to answer straightforward questions about fields such as sales quantity, product or region without first building a separate report. Chandoo demonstrates the workflow with a sales dataset and shows the total changing as he filters it.
The method combines three Excel features: a table, its Total Row option and slicers. A table gives the data a structured format; the Total Row adds a calculation at the bottom; slicers provide clickable filters for selected columns. Together, they let you narrow the displayed records and read a calculation for that filtered view.
In the demonstration, the data includes sales quantities, products and regions. Chandoo creates a table named Sales, adds a total for the quantity sold, and adds slicers for Product and Region. Clicking a region or product filters the table, and the total updates to reflect the visible values.
This is a lightweight way to explore a dataset interactively. It does not require setting up a chart or a PivotTable for the particular questions shown. For more Excel guidance and related coverage, see our Excel topic page.
The workflow is aimed at people working directly with a list of data in Excel who want to filter by one or more fields and quickly inspect a calculation. The example uses sales records, but the described process depends on having a data range with columns that can serve as table fields and slicer choices.
Start with the dataset in a worksheet. The demonstration does not rely on a separate analytics service: the table, total and slicers are set up in Excel. It uses the Table Design tab to turn on the Total Row and the Insert tab to add slicers. The steps shown use the Ctrl+T keyboard shortcut to create a table.
The example calculates a sum and then changes the calculation to an average. Choose a column whose values make sense for the calculation you want to display. The demonstrated quantity column supports both a sum and an average; the total row’s result is intended to change as slicers filter the records.
The total row uses the SUBTOTAL function. In the example, function number 109 sums the visible values in the quantity column. For an average instead, replace 109 with 101. Changing the function changes what the total row calculates while the slicer filters determine which values are included.
This approach answers questions that can be expressed by filtering table fields and applying a total-row calculation. The example focuses on a sum or average for a selected field; the demonstrated workflow does not describe a broader report-building process. The total is a single calculation, while slicers let you change the records included in it.
Before using the result, make sure the field chosen for the total matches the question you are asking. A sum answers a different question from an average, and the visible selection depends on the slicer choices. If multiple slicer items are selected, the calculation reflects the filtered set rather than just one item.
PivotTables are the other method Chandoo identifies for quick data analysis. They are an alternative to this table-and-slicer setup, although the demonstration does not explain their steps. For a quick view of one calculation across filter selections, the table approach keeps the calculation in the total row and makes the filters directly clickable.
Select the table, open the Table Design tab and enable Total Row. Choose the calculation you want in the relevant column.
Select a cell in the table, use Insert to add a Slicer, and choose fields such as Product or Region. Click slicer buttons to filter the records.
The demonstrated total row uses SUBTOTAL, which calculates from visible values. Its result changes as slicers filter the table.
The example uses 109 to sum visible values and 101 to calculate their average.