Percentile in Pivot Tables??

Josh · Feb 21st, 2002, 02:18 PM

Does anyone know if you can perform the Percentile Function in Pivot Tables like you can do with Sum, Count, Standard Deviation, etc.? This would help me sooooo much!
Thanks!

Mark W. · Feb 21st, 2002, 02:18 PM

You can't

Wondering Nomad · Nov 22nd, 2005, 02:52 PM

Is this still the case?

I need to summarize Minimum, Maximum, Median, 1st Quartile, and 3rd Quartile for a large number of Managers. Any idea how to do that if I can't use a pivot table?

Greg Truby · Nov 22nd, 2005, 03:29 PM

As near as I can see, yes, this is still the case. But you might be able to do something with array formulas:

******** ******************** ************************************************************************>

Microsoft Excel - book2

___Running: 11.0 : OS = Windows XP

(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout

=

A

B

C

D

E

1

Values

Region

north

0.25

1.25

2

0

north

south

0.75

9

3

1

north

4

2

north

5

3

north

6

4

north

7

5

north

8

6

south

9

7

south

10

8

south

11

9

south

12

10

south

Sheet1

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

Wondering Nomad · Nov 28th, 2005, 03:45 PM

Thanks, I think that just might work for me.

sabot7726 · Aug 15th, 2011, 07:05 PM

Is this still the case, that you can't use PERCENTILE in pivot tables? This last post was in 2005 like 30 years ago.

Aug 15th, 2011, 07:05 PM	#6
sabot7726 New Member Join Date: Jun 2006 Posts: 26	Re: Percentile in Pivot Tables?? Is this still the case, that you can't use PERCENTILE in pivot tables? This last post was in 2005 like 30 years ago.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 02:18 PM	#1
Josh New Member Join Date: Feb 2002 Posts: 1	Does anyone know if you can perform the Percentile Function in Pivot Tables like you can do with Sum, Count, Standard Deviation, etc.? This would help me sooooo much! Thanks!

Feb 21st, 2002, 02:18 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	You can't

Nov 22nd, 2005, 02:52 PM	#3
Wondering Nomad New Member Join Date: Oct 2004 Location: Los Angeles Posts: 7	Is this still the case? I need to summarize Minimum, Maximum, Median, 1st Quartile, and 3rd Quartile for a large number of Managers. Any idea how to do that if I can't use a pivot table?

Nov 28th, 2005, 03:45 PM	#5
Wondering Nomad New Member Join Date: Oct 2004 Location: Los Angeles Posts: 7	Thanks, I think that just might work for me.