In a Pivot Table, I have the following columns:

column B = Billing Rate
column C = Hours for May
column D = Hours for June
column E = Hours for July

Under each month, I want to take the existing hours and multiply against the billing rate, then display that result in place of the hours which is what is currently showing. I tried Show Values as, but the only options pertain to showing as % of Column Total, Row Total, etc.

I know I can add a calculated field that gives me the value of hours x billing rate, but I don't want to do it that way. Besides, the new column gets added at the end instead of next to the month in question.

So in summary, I want to keep the existing fields but show the results as a product of the hours x Billing Rate. This would require locking the cell reference to column B as I copy the formula across each column/month.