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?

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

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?

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

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

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