ExcelBanter - median in a pivot chart?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - median in a pivot chart? (https://www.excelbanter.com/excel-discussion-misc-queries/108778-median-pivot-chart.html)

Sung

median in a pivot chart?

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

All times are GMT +1. The time now is 05:50 AM.