Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 30th 08, 10:02 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 13
Default Row Grand Totals in Pivot Tables?

I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
ideas?

  #2   Report Post  
Old July 30th 08, 10:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 52
Default Row Grand Totals in Pivot Tables?

Hi adodson
See if the article at
http://www.techonthenet.com/excel/pi...al_col2007.php
does what you want.

Regards,
Pedro J.

I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
ideas?

  #3   Report Post  
Old July 31st 08, 12:14 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 13
Default Row Grand Totals in Pivot Tables?

Yeah, that is what I would expect it to do too. However, I set that option
and don't receive the total.

Can you think of anything else that might cause this?

"Infinitogool" wrote:

Hi adodson
See if the article at
http://www.techonthenet.com/excel/pi...al_col2007.php
does what you want.

Regards,
Pedro J.

I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
ideas?


  #4   Report Post  
Old July 31st 08, 04:46 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,979
Default Row Grand Totals in Pivot Tables?

You'll see grand totals for rows if you have a field in the Columns
area, with multiple items.
If you don't have column fields, you won't see row totals.

adodson wrote:
I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
ideas?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

  #5   Report Post  
Old May 22nd 09, 02:52 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 2
Default Row Grand Totals in Pivot Tables?

I am having the same problem as adodson. I have data from a survey given to
students and I want to create a scale. I have the averages of the questions
in my scale with a row for each class (i.e. freshmen, sophomore, etc.) I want
the row totals to show up because that would be the scale average for each
class. I have turned on row grand totals in the design menu and in the pivot
table options menu but they just won't show up.
Do you know why this is????
I am using Office 2007 Professional Edition with service pack 2

"Debra Dalgleish" wrote:

You'll see grand totals for rows if you have a field in the Columns
area, with multiple items.
If you don't have column fields, you won't see row totals.

adodson wrote:
I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
ideas?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com




  #6   Report Post  
Old May 30th 09, 08:55 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,979
Default Row Grand Totals in Pivot Tables?

In your source data, do you have a separate column for each class, or
are all the responses in the same column?
Can you describe how your source data is set up, and where each field is
placed in the pivot table?


[email protected] wrote:
I am having the same problem as adodson. I have data from a survey given to
students and I want to create a scale. I have the averages of the questions
in my scale with a row for each class (i.e. freshmen, sophomore, etc.) I want
the row totals to show up because that would be the scale average for each
class. I have turned on row grand totals in the design menu and in the pivot
table options menu but they just won't show up.
Do you know why this is????
I am using Office 2007 Professional Edition with service pack 2

"Debra Dalgleish" wrote:


You'll see grand totals for rows if you have a field in the Columns
area, with multiple items.
If you don't have column fields, you won't see row totals.

adodson wrote:

I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
ideas?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

  #7   Report Post  
Old June 1st 09, 03:36 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 2
Default Row Grand Totals in Pivot Tables?

My data is set up so that each row represents a respondent's answers and each
column represents a question asked. The class designation is a question so it
is all represented in one column.

"Debra Dalgleish" wrote:

In your source data, do you have a separate column for each class, or
are all the responses in the same column?
Can you describe how your source data is set up, and where each field is
placed in the pivot table?


[email protected] wrote:
I am having the same problem as adodson. I have data from a survey given to
students and I want to create a scale. I have the averages of the questions
in my scale with a row for each class (i.e. freshmen, sophomore, etc.) I want
the row totals to show up because that would be the scale average for each
class. I have turned on row grand totals in the design menu and in the pivot
table options menu but they just won't show up.
Do you know why this is????
I am using Office 2007 Professional Edition with service pack 2

"Debra Dalgleish" wrote:


You'll see grand totals for rows if you have a field in the Columns
area, with multiple items.
If you don't have column fields, you won't see row totals.

adodson wrote:

I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
ideas?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com


  #8   Report Post  
Old June 1st 09, 06:58 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,979
Default Row Grand Totals in Pivot Tables?

If every question is in a separate column in the source data, then
you're adding them to the pivot table as separate fields in the data area.
Because they're separate fields, the Row Grand Total won't calculate
their total.
You could create a calculated field with a formula to sum them.

[email protected] wrote:
My data is set up so that each row represents a respondent's answers and each
column represents a question asked. The class designation is a question so it
is all represented in one column.

"Debra Dalgleish" wrote:


In your source data, do you have a separate column for each class, or
are all the responses in the same column?
Can you describe how your source data is set up, and where each field is
placed in the pivot table?


[email protected] wrote:

I am having the same problem as adodson. I have data from a survey given to
students and I want to create a scale. I have the averages of the questions
in my scale with a row for each class (i.e. freshmen, sophomore, etc.) I want
the row totals to show up because that would be the scale average for each
class. I have turned on row grand totals in the design menu and in the pivot
table options menu but they just won't show up.
Do you know why this is????
I am using Office 2007 Professional Edition with service pack 2

"Debra Dalgleish" wrote:



You'll see grand totals for rows if you have a field in the Columns
area, with multiple items.
If you don't have column fields, you won't see row totals.

adodson wrote:


I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
ideas?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

  #9   Report Post  
Old June 1st 09, 07:52 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2008
Posts: 3
Default Row Grand Totals in Pivot Tables?

I've been having the same problem. I think the report format template makes a
difference. There are "Indented" and "Non-Indented" formats. If you selected
Autoformat and chose a report template, the row summary functionality does
not seem to work with Indented templates (formats referred to as Report 1-10).

"Debra Dalgleish" wrote:

If every question is in a separate column in the source data, then
you're adding them to the pivot table as separate fields in the data area.
Because they're separate fields, the Row Grand Total won't calculate
their total.
You could create a calculated field with a formula to sum them.

[email protected] wrote:
My data is set up so that each row represents a respondent's answers and each
column represents a question asked. The class designation is a question so it
is all represented in one column.

"Debra Dalgleish" wrote:


In your source data, do you have a separate column for each class, or
are all the responses in the same column?
Can you describe how your source data is set up, and where each field is
placed in the pivot table?


[email protected] wrote:

I am having the same problem as adodson. I have data from a survey given to
students and I want to create a scale. I have the averages of the questions
in my scale with a row for each class (i.e. freshmen, sophomore, etc.) I want
the row totals to show up because that would be the scale average for each
class. I have turned on row grand totals in the design menu and in the pivot
table options menu but they just won't show up.
Do you know why this is????
I am using Office 2007 Professional Edition with service pack 2

"Debra Dalgleish" wrote:



You'll see grand totals for rows if you have a field in the Columns
area, with multiple items.
If you don't have column fields, you won't see row totals.

adodson wrote:


I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
ideas?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table row grand totals Vin Excel Discussion (Misc queries) 0 June 18th 08 10:42 AM
Grand Totals for Pivot Tables ExcelPeter218 Excel Discussion (Misc queries) 4 March 17th 08 01:42 AM
Pivot Totals: Group totals different from Grand totals PsyberFox Excel Discussion (Misc queries) 1 February 13th 08 07:16 PM
Pivot Tables - Grand Totals Tony Excel Discussion (Misc queries) 2 May 31st 06 02:06 PM
Need help with grand totals in pivot table Missygal Excel Discussion (Misc queries) 1 May 16th 06 07:02 PM


All times are GMT +1. The time now is 01:10 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017