Pivot Table Fields: Median function?

  • Thread starter Thread starter Rosie
  • Start date Start date
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.
 

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