Using formulas to modify pivot table values

[Guest]

Is there a way to modify the output of the data in the body of a pivot table
to be included in a calculaton. Of course this can be done post pivot table
creation but I would like to do it in one go. I need to divide all the
counted values in the body of the pivot table by a cell value, which is
different for each row of the pivot table.

Help would be much appreciated.

 

[Dave Peterson]

I don't think so.

Maybe you could add an extra column and do your calculation against that (and
include it in the pivottable).

Or copy the pivottable and convert to values and do what you want.