Toad World® Forums

Grand Totals in pivot grids


Can you tell me how to remove the grand totals to the right and bottom of a pivot grid? I’ve tried everything I can think of and nothing works.


On the Chart part of the window there is a toolbar with a drop down with Chart Selections. You can de-select the totals.



Debbie – I tried that but it didn’t work. Here’s a screen shot of my pivot grid.

Pivot grid VV.jpeg


Try selecting all of the rows. I think by default the grid selects the first row and that is what you are seeing in the graph.


I also have the same question - I posted a separate thread about pivot grids and still can’t figure out how to get rid of the grand totals on the pivot grid section, not the chart. I removed the sum totals from every column in my grid, but that did not work. I also don’t see a totals options section in the setup grid window. Is there not a way to get rid of the grand totals?