median in a pivot chart?

S

Sung

Does anyone know how to get a median in a pivot chart? You know in Field
Settings, Summarize by there's several selectoon, Sum, Count ......, but no
Median. Anybody know a workaround? Looked into Formula, Calculated fields,
but Excel take the summation of this.

thx
 
Top