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.
 

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

Top