Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2001
    Location
    MO
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Custom Function for Pivot Table (2000)

    Excel can do a median function, but apparently it is not available in a Pivot Table. Does anyone know a method for getting a Pivot Table to calculate a Median with the data?

  2. #2
    New Lounger
    Join Date
    Oct 2001
    Location
    Northern VA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom Function for Pivot Table (2000)

    You can insert functions by right-clicking the pivot table, then choosing Functions, then Calculated Field. You write your formula while double-clicking the Fields where you want them inserted. [This is a great way to add percentages if you need to add them to a table.]

    For Median, just type in the Median formula (like you would in a cell) only using the field instead of a range, so if you wanted a Median of a bunch of scores and the field name is Scores, then it would look like =Median(Scores).

    Hope this helps!

    Eve

  3. #3
    New Lounger
    Join Date
    Jun 2001
    Location
    MO
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom Function for Pivot Table (2000)

    This seems to do a median function on each cell involved in the field, then sum them anyway for each cell in the pivot table. The pivot tables have only the limited functions for display the data for each intersection, and the calculated function seems to just be performing the calculations on each of the values in the corresponding field prior to the pivot table function summarizing the results. This would work for some functions, but not for a median. The median of 1 number is itself, and summed would then be the same as the sum without the median. Any other ideas on this?

  4. #4
    New Lounger
    Join Date
    Oct 2001
    Location
    Northern VA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom Function for Pivot Table (2000)

    Sorry, I didn't think of that. Is there a reason it has to be in a pivot table?

Posting Permissions

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