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.

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" wrote in message
...
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.

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" wrote:

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" wrote in message
...
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.

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

"Joey" wrote in message
...
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" wrote:

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" wrote in message
...
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.