Pivot Table Fields: Median function?

  • Thread starter Thread starter Rosie
  • Start date Start date
R

Rosie

Hi. Is there a way to summarize a field using MEDIAN? It's not one of the
options.
 
Hi Rosie,

No, unfortunately there is no way of using MEDIAN inside a pivot table.


regards
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
Hi Rosie

there is no median function within the PT, only Average.
You could have a column outside your PT in which you sued the formula
=MEDIAN(SourceTable_Column)
inserting the correct references for the source.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Median Calculation 7
Median in pivot tables 5
Pivot Tables 1
Median If Function 3
Median If in Excel not working 4
Median with Quantity Column 3
Complex Median Formula 0
Excel's Pivot Table & Subtotal function should have a median fie. 1

Back
Top