grand totals in pivot table rows

  • Thread starter Thread starter pat67
  • Start date Start date
P

pat67

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
 
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 said:
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
Click to expand...

__________ 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
 
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...e64-image-encoding-via-the-data-protocol.aspx
 
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 Countof
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






__________ 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
Click to expand...

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
 
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 asa separate pie slice and making the whole pie off.

thank you!!!!
 
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!!!!
Click to expand...

Just Check, under the Rows field of pivot, uncheck the show totals button
 
Back
Top