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.
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
