Can I calculate quartiles in an Excel 2007 pivot table?

  • Thread starter Graeme Williams
  • Start date
G

Graeme Williams

When I build a pivot table, I can use the sum, average, minimum or maximum of
the data values. Can I use quartiles as well?
 
P

pshepard

Hi Graeme,

Unfortunately Quartile is not a summary option for pivot tables, nor is
median.

However there is a worksheet function:

=QUARTILE(A:A,2)

which is the same as

=MEDIAN(A:A)

Hope this helps.

PShepard
 
J

John Calder

I am no expert but you can create "helper" columns in your database that
calculates your quarterly figures then use these in a new pivot table.

or

You can create formulas within the pivot table to add together the data you
need (depends on how your data is contructed)

or

you can add a date range to you pivot table that allows you to select data
between 2 different dates.

http://www.contextures.com/excelfiles.html#Pivot

I use this all the time for my pivot table.....its great.

Cheers

John
 
Top