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

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

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