how to divide all values with a fixed value ?

F

fax

how can i divide all values in one data column in a pivottable with the
same data value in another column in the same pivot table ? how do you
specify the reference in the calculated field so it always takes the
same 1 value ?

this is very urgent. thanks in advance.
 
E

Elkar

I think what you're looking for is an Absolute Reference. So, let's say your
fixed value is in cell B1. Refer to B1 as $B$1. That way, when you copy and
paste your formula, B1 will remain fixed and won't increment. Sorry if
that's not what you're asking for. If not, please clarify.

HTH,
Elkar
 
F

fax

thanks for the reply. i need to do this in a pivot table. cant use the
referencing structure in calculated fields unfortunately..
 
Top