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?