Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 13

Thread: Count Unique Values In Pivot Table

  1. #1
    Join Date
    1st February 2008
    Posts
    7

    Count Unique Values In Pivot Table

    Hi All!

    I have a worksheet with a list of employees and the workgroup they belong to, along with other data like manager, start dates, etc. Recently a couple of the workgroups were duplicated (change in managers), so these employees are showing up on two rows even though the workgroup has the same name. The only differences in the two rows are the workgroup effective start and end dates. I need to be able to count, in a pivot table, the number of unique employee/workgroup combinations there are per workgroup. I can add columns to the sheet, but it's a dynamic set of data that will grow each time it's refreshed... Please offer any solutions you can think of!

    Thanks!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th February 2008
    Location
    Houston
    Posts
    206

    Re: Count Unique Values In Pivot Table

    Can you post a sample of the spreadsheet?

    Regards,

    -Dude
    The Dude Abides

  3. #3
    Join Date
    1st February 2008
    Posts
    7

    Re: Count Unique Values In Pivot Table

    Hi Dude, Here's an abbreviated sheet, with names changed to protect personal info and some irrelevent columns removed.. I need to get an accurate count of how many "resources" are in each workgroup...

    Thanks!

    D_
    Last edited by dmcdonald; February 28th, 2008 at 05:12.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    15th February 2008
    Location
    Houston
    Posts
    206

    Re: Count Unique Values In Pivot Table

    Before I look into this have you checked out any of the other questions in regards to this issue? Especially the ones linked in this thread?

    Count Of Unique Values With Duplicates
    Count Unique Values, For Specific Values
    Count Pivot Table Unique Values
    pivot table+put unique data in 'row area'+count of items in 'data area'

    Regards,

    -Dude
    The Dude Abides

  5. #5
    Join Date
    1st February 2008
    Posts
    7

    Re: Count Unique Values In Pivot Table

    Hi Dude, Yes, I searched for answers before I posted this question, but I haven't found one that addresses both the multiple criteria and the need to get the unique count into a pivot table.. Also I can't have a lookup table because we won't always know when the data changes.. the excel sheet is linked to a sql server and the idea is to completely automate the reporting process...

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    23rd October 2003
    Location
    France Alsace
    Posts
    3,612

    Re: Count Unique Values In Pivot Table

    Perhaps this could be a beginning.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Triumph without peril brings no glory: Just try

  7. #7
    Join Date
    1st February 2008
    Posts
    7

    Re: Count Unique Values In Pivot Table

    Hey thanks for tryin PCI! That's not exactly what I'm looking for. I've been trying a few things and have come up with this, though I'm not sure if it will work.. It depends on the sort order of the raw data (which hopefully won't change, I can talk to the database guys), and it depends on whether the range in the sum product will automatically expand as the data does... maybe there is a way to ensure that the sumproduct range expands? Please see attached...

    Thanks again!
    Last edited by dmcdonald; February 28th, 2008 at 05:12.

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    15th March 2007
    Location
    LONDON, UK
    Posts
    1,377

    Re: Count Unique Values In Pivot Table

    dmcdonald please can you save your file type as excel 97-2003 there's still a few of us here that don't have 2007...

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    1st February 2008
    Posts
    7

    Re: Count Unique Values In Pivot Table

    apologies!
    Last edited by dmcdonald; February 28th, 2008 at 05:12.

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    15th February 2008
    Location
    Houston
    Posts
    206

    Re: Count Unique Values In Pivot Table

    Dmcdonald i cant view the pivot table as the file is in 03 the table was created in 07...
    The Dude Abides

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Count Of Unique Values In Pivot Table
    By Margs in forum EXCEL HELP
    Replies: 5
    Last Post: June 19th, 2008, 06:03
  2. Count Unique Values, For Specific Values
    By CallMeJD in forum EXCEL HELP
    Replies: 4
    Last Post: September 14th, 2006, 10:07
  3. Count Pivot Table Unique Values
    By DWF in forum EXCEL HELP
    Replies: 4
    Last Post: October 2nd, 2004, 04:36
  4. Replies: 3
    Last Post: September 1st, 2004, 15:44

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
  •  
porno