Effective February 22, 2024, Google Groups will no longer support new Usenet content. Posting and subscribing will be disallowed, and new content from Usenet peers will not appear. Viewing and searching of historical data will still be supported as it is done today.
Dismiss

grand totals in pivot table rows

13,570 views
Skip to first unread message

pat67

unread,
Jan 18, 2011, 4:11:00 PM1/18/11
to
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

Shelia

unread,
Jan 20, 2011, 11:46:25 AM1/20/11
to
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/tutorials/aspnet/70f76817-e6d2-415d-8849-849d8c6c5385/aspnet-base64-image-encoding-via-the-data-protocol.aspx

Roger Govier

unread,
Jan 19, 2011, 3:02:31 AM1/19/11
to
Hi Pat

It all depends what data you have in your Data area. Some fields are not
additive, in which case a Grand Total will not appear.
For example if you had Customer as a Row field and Sum of Value and Count of
Value in the Data area, then Grand Total would not appear, but if you had
Value This Year and Value Last Year in the Data area, then a Grand Total for
both years would appear

--

Regards
Roger Govier

"pat67" <pbu...@comcast.net> wrote in message
news:96ec606e-9766-4d8b...@j1g2000vbl.googlegroups.com...

> __________ Information from ESET Smart Security, version of virus
> signature database 5798 (20110118) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 5798 (20110118) __________

The message was checked by ESET Smart Security.

http://www.eset.com


__________ Information from ESET Smart Security, version of virus signature database 5804 (20110120) __________

The message was checked by ESET Smart Security.

http://www.eset.com

pat67

unread,
Jan 28, 2011, 2:18:37 PM1/28/11
to
On Jan 19, 3:02 am, "Roger Govier" <ro...@technology4nospamu.co.uk>
wrote:

> Hi Pat
>
> It all depends what data you have in your Data area. Some fields are not
> additive, in which case a Grand Total will not appear.
> For example if you had Customer as a Row field and Sum of Value and Count of
> Value in the Data area, then Grand Total would not appear, but if you had
> Value This Year and Value Last Year in the Data area, then a Grand Total for
> both years would appear
>
> --
>
> Regards
> Roger Govier
>
> "pat67" <pbus...@comcast.net> wrote in message

>
> news:96ec606e-9766-4d8b...@j1g2000vbl.googlegroups.com...
>
> > 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
>
> > __________ Information from ESET Smart Security, version of virus
> > signature database 5798 (20110118) __________
>
> > The message was checked by ESET Smart Security.
>
> >http://www.eset.com
>
> __________ Information from ESET Smart Security, version of virus signature database 5798 (20110118) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
> __________ Information from ESET Smart Security, version of virus signature database 5804 (20110120) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com

I think it has to do with the date field being in the row labels.
because when i move it to column labels it totals

fho...@cesa1.k12.wi.us

unread,
Jun 5, 2013, 12:15:35 PM6/5/13
to
I'm trying to remove the grand totals.
I have data label in "rows" and the same in "values" so i can count each unique text and count the number of times they appear, and then show that in a pie chart. any ideas on how to remove the grand total? it is showing as a separate pie slice and making the whole pie off.

thank you!!!!

shashank...@gmail.com

unread,
Feb 7, 2014, 2:27:37 AM2/7/14
to
Just Check, under the Rows field of pivot, uncheck the show totals button

gopalsi...@gmail.com

unread,
Jul 16, 2019, 9:40:41 AM7/16/19
to
Reply all
Reply to author
Forward
0 new messages