calculations in pivottable

[Six]

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

 

[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.

 

[Stefano Rossi]

PIVOT & MEDIAN

Hi,
have you found a solution to insert median or percentile in a pivoy table?
I'm looking for that but it seems impossible.
Thanks,
Cheers
Stefano


>-----Original Message-----
>Yes, when you set up the table, at the point where you
>determine if your data is to be summed, counted,
averaged,
>or what not, there is an Option>> button. Click that and
>select Show Data as % of (row, column, what ever). If
you
>already have a pivot you would like to convert to %, open
>up the wizard, click the Layout button, double-click the
>data field, click Options>> button and pick from the Show
>data as list.
>
>
>>-----Original Message-----
>>Pivot table easily offer calculations on average,
>count...
>>I want to use some more complex functions, in particular
>>the percentile function... any clue ?
>>.
>>
>.
>[/QUOTE]