Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Percentile in Pivot Tables??

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can't

  3. #3
    New Member
    Join Date
    Oct 2004
    Location
    Los Angeles
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #4
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39 17' 15" N, -94 40' 26" W
    Posts
    9,968
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default

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

    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

  5. #5
    New Member
    Join Date
    Oct 2004
    Location
    Los Angeles
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, I think that just might work for me.

  6. #6
    Board Regular
    Join Date
    Jun 2006
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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