Create a set of tables that spin off a slicer with a total button. This helps users who are unfamiliar with slicers click a consolidation button and with sound Excel spreadsheet setup the file updates seamlessly.
https://www.thesmallman.com/blog/2020/10/17/change-pivot-table-filter-from-cell