+ Reply to Thread
Results 1 to 4 of 4

No distinct count function in pivot table

  1. #1
    Registered User
    Join Date
    09-25-2015
    Location
    NY, USA
    MS-Off Ver
    360 for Mac
    Posts
    2

    No distinct count function in pivot table

    I just purchased the latest MS Office subscription for Mac, specifically so I could access the latest version of Excel so that I could use distinct count in pivot tables. But it does not appear in the "Summarize by" dialogue box as a choice. Any advice? Is is available as an add-on by any chance? Thanks for any help

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,448

    Re: No distinct count function in pivot table

    Have you tried Debra's workarounds

    http://www.pivot-table.com/2012/02/2...th-powerpivot/

    One other way you could consider would be to build an extra column into the data rows which calculate the unique occurrencies of each item. Then either accept that there will be many occurrencies of the unique number for each item or modify the count formula to only show the first unique count value. Then include this additional column in a regular Pivot Table.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    09-25-2015
    Location
    NY, USA
    MS-Off Ver
    360 for Mac
    Posts
    2

    Re: No distinct count function in pivot table

    Thanks - so I'm really out of luck with this function? Why does Excel 2013 for PCs has it but not my (even later) version? I was hoping not to have to take these extra steps

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,192

    Re: No distinct count function in pivot table

    Are we talking about DISTINCT values or UNIQUE values here ?

+ 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. Get distinct values using pivot table
    By mavericky10 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-12-2015, 09:21 AM
  2. [SOLVED] Pivot Table that performs a distinct count in excel 2013
    By tdf2437 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-09-2014, 09:03 AM
  3. Pivot Table with Distinct Values
    By Ziggy4e in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-21-2014, 11:11 PM
  4. How to count distinct values from table in pivot table
    By gopijadhav in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-04-2014, 07:14 AM
  5. [SOLVED] How do I set up Distinct Count in a Pivot Table?
    By STOFF in forum Excel General
    Replies: 1
    Last Post: 04-18-2006, 01:25 PM
  6. count distinct in Pivot table
    By soe in forum Excel General
    Replies: 1
    Last Post: 02-22-2005, 10:06 AM
  7. Count Distinct Values by Group Using Pivot Table (NM)
    By MCP in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2005, 06:06 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