Median Value in Pivot Table

[Juan Sanchez]

Hi all,

Does any one knows if there is a way to use a diferent
function that the ones listed in the Data Items Field
Settings/Summarized By List??

I want the output to be the median of all values.

i.e.

TAPE LEN
A 1
A 3
A 7
B 6
B 7
B 12
C 8
C 9
C 12

will give this results

A B C
3 7 9

Real table has over 1000 values so it is really painfull
doing it by hand...

Any help is greatlly appreciated.

 

[Juan Pablo González]

Using an array formula in the form of

=MEDIAN(IF(condition, value))

should work, something like

=MEDIAN(IF($A$2:$A$100=E$1,$B$2:$B$100))

where A2:B100 contains your values, and E1 is the condition.

 

[Juan Sanchez]

Thanks Juan Pablo
That is what i've been doing so far, but wanted it on a
pivot table for meeting purposes, while on a work meeting
the boss ussually wants to se the median for say tape A,
now lets see tape b, now tape z and there are alot of
combinations so having each separatelly makes a 30+Mb file
e-mail immpossible.

Thanks anyways... Juan