Pivot Table Function (can it be done)!?!

[Phutile]

I want to have a formula within my pivot table like this: =stdev('act lbs/hr')*2. I'm guessing that Excel doesn't allow funtions in the pivot table formulas. I was able to get just the stdev of act lbs/hr by putting the act lbs/hr column data into the pivot table and going to field settings and changing it from sum to stdev. However, that doesn't allow me to multiply it by 2, which I would like to do. Are excel pivot tables limited function wise? Can anyone help here?
thanks!

 

[Mark W.]

See the Excel Help topic for "Syntax for calculated field and item formulas in PivotTable and PivotChart reports".