a query for pivot table

A

Arvind

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.
 
B

Bernie Deitrick

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
 

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

Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table 1
about pivot table 1
Pivot table questions 1
Issue with pivot table 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Access #Error & Excel Pivot 0
Formulas available in pivot table and grouping drop-down menus 1

Top