Results 1 to 3 of 3

Excluding duplicate values from Pivot Tables?

Threaded View

elfiky Excluding duplicate values... 09-28-2012, 01:10 PM
dlorenzo Re: Excluding duplicate... 09-28-2012, 03:01 PM
elfiky Re: Excluding duplicate... 10-01-2012, 12:14 AM
  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

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