If the Subtotals command is grayed out, that’s because subtotals can’t be added to tables. But there’s a quick way around this. Convert your table to a range of data. Then you can add subtotals. Just remember, converting to a range takes away the advantages of a table.

It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.

To add subtotals in a table, you must first convert the table to a normal range of data, and then add the subtotal. Note that this will remove all table functionality from the data except table formatting.

Remove calculated subtotal rows from a worksheet and remove subtotals from a PivotTable in Excel.

To add subtotals in a table, you must first convert the table to a normal range of data, and then add the subtotal. Note that this will remove all table functionality from the data except table formatting.

In this scenario, the Excel workbook contains automatic subtotals that should not be present, based on the visibility toggle feature that you use. This issue occurs because of an error in the Excel renderer in SQL Server 2008 R2 Reporting Services. The fix for this issue was first released in Cumulative Update 5.

To use a different function, to display more than one type of subtotal, or to subtotal an inner row or column label, click Custom (if this option is available), and then select a function.

If you want, your grouped detail rows can have a corresponding summary row—a subtotal. To create these, do one of the following: Use the Subtotal command, which inserts the SUBTOTAL function immediately below or above each group of detail rows and automatically creates the outline for you.

Unfortunately, this means that Excel can't understand what you're trying to do, so you'll need to update your formula or make sure you're using the function correctly.

The Totals Row lets you pick which aggregate function to use for each column. Click the cell in the Totals Row under the column you want to adjust, then click the drop-down that appears next to the cell.