PivotTable Totals

[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.

 

[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.

 

[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?

 

[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