Adding a new Totals Column
Hello!
I'm trying to figure out how I can add a Grand Totals column to my pivot chart.
I considered simply making a grand total column that is not connected to my table, but after I thought about it, I need it with the table.
I have the Grand total row at the bottom of the chart, but for the life of me cannot figure out how to make a column on the end of my PivotChart.
right click on the
right click on the pivot
pivot table options
totals and filters
show grand totals for rows...