Use % of Total in Excel pivot table

[WaltW]

I have a pivot table that currently has 3 columns (among others): (1) Hours (as a sum), (2) Hours (as % of total), and (3) total $ amount. In each row of the pivot table, I'd like to be able to multiply the percentage calculated for the hours as % of total by the total $ amount, but can't seem to make it work. What's the trick? Any suggestions?

Thanks!
Walt

 

[GlennUK]

Do you mean that you want the "hours as % of total" multiplied by the "Grand total $ amount"?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[WaltW]

Thanks for responding, Glenn.

No. I have a $ amount listed in each row of the pivot table. I'd like to multiply "hours as % of total" by THAT $ amount, in each row. Thanks!

Regards, Walt