I have a Pivot Table and would like to use the MODE function instead of
the standards they provide (sum, min, max, etc.) -- so I have gone to
Pivot Tables Formulas Calculated Field and attempted to use the
following formula:
=MODE(fieldname)
It doesn't give me errors and it creates a new field called Field1 and
adds it to the Pivot Table, however, it gives me the sum.
I have never worked with adding custom formulas before -- and help is
not much help.
------
-----
--
GoDario27
------------------------------------------------------------------------
GoDario27's Profile:
http://www.excelforum.com/member.php...o&userid=26313
View this thread:
http://www.excelforum.com/showthread...hreadid=502978