View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SB Lee[_2_] SB Lee[_2_] is offline
external usenet poster
 
Posts: 9
Default Median in pivot tables

Is there another way to easily show a list of medians for the applicable jobs
and then incorporate it in to the pivot table or at least show it as a stand
alone statistic?

"Debra Dalgleish" wrote:

The Median function isn't available to summarize Pivot Table fields.

SB Lee wrote:
By using pivot tables, I am showing statistical data for base pay for several
hundred different jobs and need to add statistics for the median. How can i
add the median to the pivot table?

Thanks.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com