Adding a Grand Total Row to your Data Destination

As Filtered Summary inserts data into the destination range, dashboard developers often desire the total values for various business uses. Rather than relying on Excel logic, Filtered Summary will automatically calculate and insert the Total values into the top or bottom row of the destination range.

filtered summary total property

By default, Filtered Summary will use the label “All” and insert it into the left-most column. You can change this label using the Total Label property. All other columns within the destination range containing text values will result in a “N/A” value.

Data Preview
filtered summary total