PivotTable Totals

J

Joey

How can I add two columns for Totals so that I can look at one column in
dollars and one column in % of total? I tried to Copy-Paste Special but the
format didn't work.
 
F

Fred Smith

Copy/Paste Special of what? You said you had a Pivot Table. In that case,
create two columns in your Pivot Table, one which is a Total, and one a %
Total. Use a different name for each column.

Regards,
Fred.
 
J

Joey

I should have clarified more...

On the PivotTable I have a list of items and the other column displays the
Total. What I would like it to have 2 Total columns that can both have Field
Settings options.

If I just cut and paste the extra column is not part of PivotTable.

Does this make better sense?
 
F

Fred Smith

Sorry, it doesn't help at all. We've agreed cut and paste is not the way to
go.

What's wrong with creating the extra column in the Pivot Table?

Fred
 
Top