Thanks:  0
Likes:  0

Thread: Percentile in Pivot Tables??

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!

2. You can't

3. 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?

4. 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
 E1E2 =

A
B
C
D
E
1
ValuesRegionnorth0.251.25
2
0northsouth0.759
3
1north
4
2north
5
3north
6
4north
7
5north
8
6south
9
7south
10
8south
11
9south
12
10south
 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.

5. Thanks, I think that just might work for me.

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

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•