Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Todd L.
 
Posts: n/a
Default pivot table question, sum fields?

Hi. I am trying to get a pivot table to subtotal a row of data in the pivot
table. I can get it to add columns at the end of the report with the
subtotals but not at the bottom of the category. How do I do this? I know
it is probably simple but I don't get it.

The table looks like this:

Manufacturer Manufacturer
Product Product Product
Product
community name
community name
community name


with a 95 comunities, 3 manufacturers and 33-40 products each manufacturer.

I need to add a sum column at the beginning of the table that tells me how
many products in total were bought from each manufacturer. Right now to get
around this I add a column at the end and put in a sum formula and format it
to look like its part of the pivot table. Kind of awkward.


Thanks so much,

Todd


  #2   Report Post  
Todd L.
 
Posts: n/a
Default

I am replying to my own question! I have been working at this at home and
its easy. I checked sum row and a grand total appears in the table. At work
I when I do that it doesn't happen. At work I am getting each category
totaled in a new column. ??? Can anyone tell me what I might be doing wrong?


Thanks,


Todd.


"Todd L." wrote:

Hi. I am trying to get a pivot table to subtotal a row of data in the pivot
table. I can get it to add columns at the end of the report with the
subtotals but not at the bottom of the category. How do I do this? I know
it is probably simple but I don't get it.

The table looks like this:

Manufacturer Manufacturer
Product Product Product
Product
community name
community name
community name


with a 95 comunities, 3 manufacturers and 33-40 products each manufacturer.

I need to add a sum column at the beginning of the table that tells me how
many products in total were bought from each manufacturer. Right now to get
around this I add a column at the end and put in a sum formula and format it
to look like its part of the pivot table. Kind of awkward.


Thanks so much,

Todd


  #3   Report Post  
Garreth
 
Posts: n/a
Default

Hi Todd. .. .

Your question is a good one. . .

This is what you do . ..

Validations sectors is in A1 and B1 right ? . . . If you want the cells to
combine then all you have to do is concatenate it, or use =A1&B1. this will
give you a result of the two cells joined. let me give you an example of
concatenating. . . . =concatenate(A1 & "-" & B1). This function joins
cells. Put it in cell C1 or where ever you want it to be. The same applies
for the =A1&B1 function. Hope this helps you alot.


Regards

Garreth from the excel maniacs ( http://www.geocities.jp/xlmaniacs/ )

"Todd L." wrote:

Hi. I am trying to get a pivot table to subtotal a row of data in the pivot
table. I can get it to add columns at the end of the report with the
subtotals but not at the bottom of the category. How do I do this? I know
it is probably simple but I don't get it.

The table looks like this:

Manufacturer Manufacturer
Product Product Product
Product
community name
community name
community name


with a 95 comunities, 3 manufacturers and 33-40 products each manufacturer.

I need to add a sum column at the beginning of the table that tells me how
many products in total were bought from each manufacturer. Right now to get
around this I add a column at the end and put in a sum formula and format it
to look like its part of the pivot table. Kind of awkward.


Thanks so much,

Todd


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 Page Fields Andy Excel Discussion (Misc queries) 1 December 17th 04 06:25 PM
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question Barb Reinhardt Charts and Charting in Excel 3 December 8th 04 02:48 AM
How Do You Permanently Format Fields of a Pivot Table? Marcia Excel Discussion (Misc queries) 1 December 6th 04 02:55 PM
Is there an autofill for all row fields in a pivot table? Wendy B Excel Worksheet Functions 2 November 10th 04 02:54 PM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 02:18 PM


All times are GMT +1. The time now is 04:48 PM.

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

About Us

"It's about Microsoft Excel"