ExcelBanter - Sum data showing when filtering a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum data showing when filtering a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/225615-sum-data-showing-when-filtering-pivot-table.html)

tarabull

Sum data showing when filtering a pivot table

When my filter changes, is there any way to automatically update the sum
based on the data that is showing?

All times are GMT +1. The time now is 12:10 PM.