grand totals in pivot table rows

January 18th, 2011 - 04:11 pm ET by pat67 | Report spam

Hi, when I look at the pivot table options i see a button to show
grand totals in rows. however, it is not working. any ideas? I am
using Excel 2007

Thanks

Follow the discussion Replies

3 replies

Make a reply

Replies

#1 Shelia

January 20th, 2011 - 11:46 am ET | Report spam

When trying to generate Grand Totals in a PivotTable, put the items to be totaled in the "Value" area of the PivotTable using the Field List window. Select the PivotTable to be updated, select the Options tab, then click on Field List in the Show/Hide group. The Value area is in the bottom right corner of the window.

Hope this helps...

Submitted via EggHeadCafe
ASP.NET Base64 Image Encoding via the Data: protocol
http://www.eggheadcafe.com/tutorial...tocol.aspx

Read all the answers

grand totals in pivot table rows

Replies

Similar topics