Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Page Fields | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
How Do You Permanently Format Fields of a Pivot Table? | Excel Discussion (Misc queries) | |||
Is there an autofill for all row fields in a pivot table? | Excel Worksheet Functions | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |