Pivot Table Disconnected Slicer
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...
