+ Reply to Thread
Results 1 to 2 of 2

Where's the Distinct Count feature in Pivot Tables?

Hybrid View

  1. 06-09-2017, 11:10 PM #1
    scokaw
    scokaw is offline
    Registered User
    Join Date
    12-01-2009
    Location
    Hawaii
    MS-Off Ver
    Excel 2010
    Posts
    30

    Where's the Distinct Count feature in Pivot Tables?

    Where is the Summarize value field by Distinct Count feature in pivot table settings? I'm using Excel 2016. I can't seem to find it.
    Reply With QuoteRegister To Reply
  2. 06-09-2017, 11:28 PM #2
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Where's the Distinct Count feature in Pivot Tables?

    When you start creating a PivotTable, you must tick Add this data to the Data Model

    dist.jpg

    and then

    dist2.jpg
    Last edited by sandy666; 06-09-2017 at 11:35 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with distinct count on Pivot table
    By Jonathan11235 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-27-2016, 07:25 AM
  2. Pivot Tables: Distinct Count of records containing more than one value for a field
    By nataliesmith in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-05-2016, 12:01 PM
  3. No distinct count function in pivot table
    By AS Mcclain in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 09-25-2015, 12:37 PM
  4. Pivot Tables-To Find Count of Unique(Distinct)User id within the same Journal Entry.
    By Deepthik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2010, 06:09 AM
  5. Distinct Counts in Pivot Tables
    By tw41 in forum Excel General
    Replies: 1
    Last Post: 06-19-2009, 02:28 AM
  6. [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
  7. [SOLVED] count distinct in Pivot table
    By soe in forum Excel General
    Replies: 1
    Last Post: 02-22-2005, 10:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1