Can I calculate quartiles in an Excel 2007 pivot table?
 

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?

Can I calculate quartiles in an Excel 2007 pivot table?
 

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


"Graeme Williams" wrote:

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?

Can I calculate quartiles in an Excel 2007 pivot table?
 

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


"Graeme Williams" wrote:

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?