Toad World® Forums

Grand Totals in pivot grids


#1

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.


#2

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
PivotTotals2.png


#3

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

Vicki
Pivot grid VV.jpeg


#4

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.


#5

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?