Is there a way to have a pivot table display a percentile as well as an average or other aggregations?

[rst]

I have used calc for quite a while, but I am just learning about pivot tables and I am seeing a lot of powerful tools.

The data that I am using is quite skewed so 95 percentile is more useful than maximum or average.
Because it is skewed, the normal equations that allow you to calculate a percentile from the mean and standard deviation aren’t very accurate.

I have looked at all of the available aggregations available in the data fields section of the Pivot table layout dialog. Is there another way to calculate and display other aggregations in the pivot table?
Thanks
Ray

[joshua4]

Your statistics is probably better than mine. But what about a helper column or two added to the data set? Here is an idea, in any case:
Possible Percentile Pivot.ods (11.8 KB)
Please do not put my statistics into use without double checking!