You could create a second pivot table, based on the first one. In one
pivot table, show the Hours, and in the other show the Dollars.

Rob wrote:
Thank you. You are correct, my data is organized as you have it below. Are
you aware if there is a way to re-organize the data from the way I have it to
the way you suggest?

"Jim Thomlinson" wrote:


As a guess your source data is not set up correctly to do that... You
probably have

Company Hours Dollars
A 10 100
B 20 300

Instead of
Company Type Amount
A Hours 10
A Dollars 100
B Hours 20
B Dollars 300

As your data stands it will be an uphill battle to get the data re-organized
as you want it...
--
HTH...

Jim Thomlinson


"Rob" wrote:


I am trying to see if you can get the totals for columns to appear right next
to the data they reference. Is this possible? See below.

Hours Dollars
Company A Company B Total Company A Company B Total
Dec 06 8 7 15 100 90
190

instead of
Hours Dollars Hours Total Dollars
Total
Co. A Co.B Co. A Co. B
Dec 06 8 7 100 90 15 190






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html