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.


--
fax
------------------------------------------------------------------------
fax's Profile: http://www.excelforum.com/member.php...o&userid=28912
View this thread: http://www.excelforum.com/showthread...hreadid=486922

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

"fax" wrote:


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.


--
fax
------------------------------------------------------------------------
fax's Profile: http://www.excelforum.com/member.php...o&userid=28912
View this thread: http://www.excelforum.com/showthread...hreadid=486922

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


--
fax
------------------------------------------------------------------------
fax's Profile: http://www.excelforum.com/member.php...o&userid=28912
View this thread: http://www.excelforum.com/showthread...hreadid=486922