close
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 gt; Formulas gt; 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: www.excelforum.com/member.php...oamp;userid=26313
View this thread: www.excelforum.com/showthread...hreadid=502978
全站熱搜
留言列表
