Pivot Table - Calculated Field

D

Daniela

Pivot tables allow you to view your data/query results
from a pre-set choice of formulas (sum, count, average,
Max, Min, etc.)
I am looking for a formula that is not on the list
(=median).
I have created a "calculated field" - but it would never
return the formula I specify - it's always the sum.

I appreciate your time/help.
Daniela
 
B

Bernie Deitrick

Daniela,

Median is unfortunately not available via pivot table. But Meidan works
well in array formulas, and you can construct your own, and generate a table
of Medians fairly easily. For example, entered with Ctrl-Shift-Enter

=MEDIAN(IF(A1:A5>0,IF(B1:B5=D1,C1:C5)))

will return the median of numbers in C1:C5 where the number in A1:A5 is
greater than 0 and the value in B1:B5 is the same as that in D1.

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 Calculated field error 1
Pivot Table Calculated Field - Sum/count 1
Using a MIN, MAX formula on a calculated field in a pivot table 0
Pivot table, IF function, calculated item versus calculated field 1
Calculates field in pivot table 2
Help with pivot calculated fields? 1
Pivot table calculated field Count(field) / sum(field) 0
Formulas in Pivot Table 4

Top