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.
0 Answers
Related