Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table query | Excel Discussion (Misc queries) | |||
Microsoft Query & Pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table Query | Excel Discussion (Misc queries) | |||
Pivot Table Query | Excel Discussion (Misc queries) | |||
Pivot Table Query | Excel Discussion (Misc queries) |