+ Reply to Thread
Results 1 to 2 of 2

How to count unique values in Pivot Table

  1. #1
    Registered User
    Join Date
    04-20-2009
    Location
    San Francisco
    MS-Off Ver
    Microsoft Excel for Mac 2011
    Posts
    5

    How to count unique values in Pivot Table

    I have a table that contains
    USER_NAME, USER_DEPARTMENT, REPORT_NAME and REPORT_RUN_DAY
    Screen Shot 2014-04-10 at 1.52.24 PM.png

    I created a pivot table as shown in the attached Picture, however for each record (row) it is counting as 1, I want to count unique number of employees for each department and unique number of reports each employee runs.

    Any help would be appreciated.

    Thanks
    Moiz

  2. #2
    Registered User
    Join Date
    04-20-2009
    Location
    San Francisco
    MS-Off Ver
    Microsoft Excel for Mac 2011
    Posts
    5

    Re: How to count unique values in Pivot Table

    Data for the pivot table

    Day Report Name User Name Department
    Day 1 Report1 John Finance
    Day 1 Report10 Eric Marketing
    Day 2 Report10 Eric Marketing
    Day 1 Report12 Eric Marketing
    Day 1 Report13 Chang Finance
    Day 2 Report2 John Finance
    Day 2 Report4 John Finance
    Day 2 Report5 John Finance
    Day 2 Report6 Alex Sales
    Day 3 Report3 John Finance
    Day 4 Report7 Alex Sales
    Day 4 Report8 Alex Sales
    Day 5 Report9 Alex Sales

+ 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 only unique values in pivot table
    By Leahmaria26 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2013, 08:56 PM
  2. Count unique values with pivot table
    By distribution master in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-07-2013, 10:47 AM
  3. Count unique values in pivot table
    By karinos57 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-10-2009, 12:03 PM
  4. Count unique values - Pivot Table
    By Thomas Mueller in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-02-2005, 06:20 PM
  5. [SOLVED] 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