Add Grand Totals on Stacked Column/Bar Pivot Charts
MOST of the time I do a Pivot Chart using stacked columns, I want to be able to see a Total for the entire stack. It should be a very simple, intuitive way to do it, but seems like a huge workaround for something that should be a given. Either as Data Labels or as an option to add the Grand Totals as a series to the PC.
David Brys commented
Have you figured out a way to do so (even it is a huge workaround)? I am looking now for days to get a way to do so. The best option I got was through a cube, but then I lost the dynamic of the pivot. Why has this so little votes! :-)