+ Reply to Thread
Results 1 to 2 of 2

is it possible to calculate the median in the pivot table

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    NY, USA
    MS-Off Ver
    Excel 2010
    Posts
    72

    is it possible to calculate the median in the pivot table

    In Pivot table field list under Values, I see two different tabs in the Value Field settings in EXCEL 2010 version,
    (a) summarize values by
    (b) show values as

    In "summarize values by" tab, the dropdown list contains
    "sum, count, average, max, min, product, count numbers, stddev, stddevp, var and varp" but NO "median".

    In "show values as" tab, there is no median either.

    Is there a way to calculate the median of the data during the process of pivoting the original data table ?

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016/Work 2013 Pro Plus
    Posts
    1,648

    Re: is it possible to calculate the median in the pivot table

    I think the answer is 'No'.

    The way I do it is pivot using a unique primary key in the Rows area, and placing the 'Sum' of the item you want a median for in the values area.

    Then have a formula outside the pivot equaling the median for the entire column that holds the sum values.

    In the example the formula is;
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Capture.JPG

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1