+ Reply to Thread
Results 1 to 3 of 3

Excluding duplicate values from Pivot Tables?

  1. #1
    Registered User
    Join Date
    05-21-2007
    Posts
    57

    Cool Excluding duplicate values from Pivot Tables?

    I have a table of six projects accross two regions. Each project got multiple vendors. I need to create pivot table showing the count of the (SIX) projects/region. The problem is pivot table count duplicate project name (due to multiple vendors/rows attached to the same project). How can I overcome the duplicate project name & count each project ONCE in the pivot table? please see attached simple report. Thank uuu
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-24-2011
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Excluding duplicate values from Pivot Tables?

    I see that you only have 5 projects on here (unless there are more projects that aren't visible). I see Projects A - E on your sheet. I can get a pivot table to show a consolidated view of each project. For example, Project A would show a total of $150,000 for "WA Amount (Pending or Approved)", total of $150,000 for "Invoices (Pending or Approved)". Is that would you would like to see in your report?
    I can also create a table to include Regions. For example, Project D would have totals for Central as well as West.

  3. #3
    Registered User
    Join Date
    05-21-2007
    Posts
    57

    Re: Excluding duplicate values from Pivot Tables?

    No. I want to create a pivot table showing the COUNT of projects in each region. When I try to do this, it shows me MORE projects because of the multiple rows/vendors attached to each project

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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