+ Reply to Thread
Results 1 to 2 of 2

Pivot table: median instead of average

  1. #1
    Registered User
    Join Date
    08-08-2020
    Location
    UK
    MS-Off Ver
    Excel for Mac 365
    Posts
    6

    Pivot table: median instead of average

    Dear all,

    I have made a couple of pivot tables with price data. Unfortunately in the value tab I can only do average of price and not median of price (see attachment).

    I have read that the power-pivot add-in can do the trick, but for some reason in my office 365 version for mac there is no option button when I open excel to activate the plug-in. Also when I do Insert --> Add-in --> Get add-in, then go to the stores, I can't find power-pivot there.

    Would be great if someone can help out...
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: Pivot table: median instead of average

    Power Pivot, Power Query and Power BI are not available in MAC versions. It is only available for Windows based systems. However, if interested in calculating next to the PT, then look at this link

    https://www.myonlinetraininghub.com/...in-pivottables
    Last edited by alansidman; 08-09-2020 at 11:47 AM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table median instead of average
    By aparatschik in forum Excel General
    Replies: 2
    Last Post: 08-09-2020, 10:09 AM
  2. Replies: 2
    Last Post: 04-26-2017, 11:28 AM
  3. Replies: 1
    Last Post: 05-10-2013, 02:03 PM
  4. [SOLVED] pivot: average vs. median
    By dave in Toronto in forum Excel General
    Replies: 2
    Last Post: 09-08-2005, 10:05 AM
  5. How can I put the median on a pivot table?
    By JAH in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-22-2005, 03:05 PM

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