danibapsilva
New Member
- Joined
- Aug 23, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I'm trying to add the grand total row from my pivot table to my slicer. My slicer currently controls A lot of my charts and I want to be able to see the subtotals/grand totals of my certain field in my pivot table, displayed onto my chart. I cannot add a calculated item to my pivot table as I keep getting an error involving my source table (Can't Be Changed). I'm open to VBA solutions as well if anybody has one.