a query for pivot table
 

Is it possible to have a median in pivot table for data. same as we are
having count or Sum function. i didnt find it in options any where.

a query for pivot table
 

Arvind,

No, you need to use worksheet functions to calculate median - you can array enter (using
Ctrl-Shift-Enter) a formula like:

=MEDIAN(IF($B$2:$B$200="NE", $C$2*:$C$200))

That will return the median of numbers in C2:C200 where B2:B200 is NE. (or use a cell reference)

HTH,
Bernie
MS Excel MVP


"Arvind" wrote in message
...
Is it possible to have a median in pivot table for data. same as we are
having count or Sum function. i didnt find it in options any where.