Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total Column in Pivot Table
I created a simple pivot table that has data in columns. The rows total
across each line, and I would like the columns to total at the bottom. The only one that provides a total is the "Total" column which is automatically generated. How do I get the other columns to show a total at the bottom? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total Column in Pivot Table
Right-click on a cell in the pivot table, and click Table Options
Add a check mark to Grand totals for Columns Click OK kleivakat wrote: I created a simple pivot table that has data in columns. The rows total across each line, and I would like the columns to total at the bottom. The only one that provides a total is the "Total" column which is automatically generated. How do I get the other columns to show a total at the bottom? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total Column in Pivot Table
Thanks, but I already have that box checked. Could it have anything to do
with the fact that the fields I'm bringing over from the data worksheet are in columns in my pivot table, not the data section that does the automatic calculations? "kleivakat" wrote: I created a simple pivot table that has data in columns. The rows total across each line, and I would like the columns to total at the bottom. The only one that provides a total is the "Total" column which is automatically generated. How do I get the other columns to show a total at the bottom? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total Column in Pivot Table
What fields are in the row area, the column area and the data area?
Which fields do you want totalled? kleivakat wrote: Thanks, but I already have that box checked. Could it have anything to do with the fact that the fields I'm bringing over from the data worksheet are in columns in my pivot table, not the data section that does the automatic calculations? "kleivakat" wrote: I created a simple pivot table that has data in columns. The rows total across each line, and I would like the columns to total at the bottom. The only one that provides a total is the "Total" column which is automatically generated. How do I get the other columns to show a total at the bottom? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total Column in Pivot Table
The data I brought in to columns includes an item number, floor location,
quantity, and 3 cost columns -- product, tax and installation. All those fields were brought in from the data sheet, so they appear as columns. None are in the data field in the pivot table. I also have a "total" column in my data, which I've tried alternately to bring in or not (I've tried letting the "total rows" option provide the total rather than bring the total from the data worksheet.) What I'm trying to do is to get costs for each floor (total product cost, total tax cost, and total installation cost), but all I'm able to get is the grand total of all that combined and I can't break out product, tax and installation. I hope this was clear enough and that I answered your questions. Thanks for your help! KK "Debra Dalgleish" wrote: What fields are in the row area, the column area and the data area? Which fields do you want totalled? kleivakat wrote: Thanks, but I already have that box checked. Could it have anything to do with the fact that the fields I'm bringing over from the data worksheet are in columns in my pivot table, not the data section that does the automatic calculations? "kleivakat" wrote: I created a simple pivot table that has data in columns. The rows total across each line, and I would like the columns to total at the bottom. The only one that provides a total is the "Total" column which is automatically generated. How do I get the other columns to show a total at the bottom? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total Column in Pivot Table
If you put the cost columns in the data area, you should see them
individually as columns. Because they're separate fields, the row won't total automatically. You could include your Total field in the data area, to see the total for each floor. kleivakat wrote: The data I brought in to columns includes an item number, floor location, quantity, and 3 cost columns -- product, tax and installation. All those fields were brought in from the data sheet, so they appear as columns. None are in the data field in the pivot table. I also have a "total" column in my data, which I've tried alternately to bring in or not (I've tried letting the "total rows" option provide the total rather than bring the total from the data worksheet.) What I'm trying to do is to get costs for each floor (total product cost, total tax cost, and total installation cost), but all I'm able to get is the grand total of all that combined and I can't break out product, tax and installation. I hope this was clear enough and that I answered your questions. Thanks for your help! KK "Debra Dalgleish" wrote: What fields are in the row area, the column area and the data area? Which fields do you want totalled? kleivakat wrote: Thanks, but I already have that box checked. Could it have anything to do with the fact that the fields I'm bringing over from the data worksheet are in columns in my pivot table, not the data section that does the automatic calculations? "kleivakat" wrote: I created a simple pivot table that has data in columns. The rows total across each line, and I would like the columns to total at the bottom. The only one that provides a total is the "Total" column which is automatically generated. How do I get the other columns to show a total at the bottom? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to include the Grand Total Column in a pivot table chart? | Charts and Charting in Excel | |||
Sub-Total Column in a pivot table | Excel Discussion (Misc queries) | |||
PIVOT TABLE - GRAND TOTAL COLUMN | New Users to Excel | |||
move column total in pivot table to begining | Excel Discussion (Misc queries) | |||
Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions |