Pivot Tables and Statistical Formulae
Posted by brendan Kenny on February 13, 2002 9:23 AM
I am looking to use pivot tables to calculate confidence interval points, but am unable to combine pivot table queries with a statistical query.
The currently available options in a pivot table are : Sum / Count / Max / Min / Avg / StdDev / StdDevp / Var / Varp
However I want to calculate the median (50th percentile) value and 80th percentile. Normally I'd use the percentile() function.
Any help would be appreciated.