+ Reply to Thread
Results 1 to 3 of 3

Adding count of unique values in a pivot

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    15

    Adding count of unique values in a pivot

    In the attached, how would I add a count in the pivot of the unique values in column A from the data sheet.
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Adding count of unique values in a pivot

    =COUNT(A:A) on the pivot sheet?
    Martin

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Adding count of unique values in a pivot

    Your profile says you're on Office 365, so you may already have the Dynamic Array functions, currently rolled out to users on the Monthly channel. With Dynamic Array functions, you can use the Unique() function to get a count of unique values, for e.g.

    =COUNTA(UNIQUE(Data!A2:A25))

    Or, if you add the source data of the pivot table to the Excel Data Model and build the pivot table from that, you can use the Distinct Count in the Value Field settings.

+ 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. [SOLVED] Count unique values in Pivot Table
    By GIS2013 in forum Excel General
    Replies: 3
    Last Post: 12-09-2016, 09:06 AM
  2. How to count unique values in Pivot Table
    By shakii in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-10-2014, 05:16 PM
  3. [SOLVED] Count unique values in pivot table
    By katy1985 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-19-2013, 06:51 AM
  4. [SOLVED] count unique values in pivot table
    By Fugazi_Dent in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 11:58 AM
  5. Count unique values in pivot table
    By karinos57 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-10-2009, 12:03 PM
  6. Count unique values - Pivot Table
    By Thomas Mueller in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-02-2005, 06:20 PM
  7. Count unique values - Pivot Table
    By Thomas Mueller in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-02-2005, 06:17 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