pivot table: divide data columns with same data field
 

how can i divide all values in one data column in a pivottable with a
fixed data value from another column in the same pivot table ? in other
words, how do you specify the reference in the calculated field so it
always takes the same 1 value ? i guess this requires vba ?

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=486941