calculations in pivottable

S

Six

sorry about it I meant PERCENTILE, not PERCENTAGE...
i.e. the equivalent of =PERCENTILE(A1:A2,0.95)
 
M

Mike

OK, I read it wrong. You can create a special calculated
field that uses a formula other that the regular sum,
average, count, etc.. Right-click your pivot table, then
select Formulas, then Calculated Field, enter your formula
and add it. I can't guarantee it will work for this
function though because I'm not familiar with it. I
suggest you test this out before appplying it to you
workbook.
 
Top