Can you remove duplicates from Pivot Table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there - i have a database which looks something like this:
Name Number
Fred 1000
Fred 1000
Fred 1000
Tom 2000
Tom 2000
Tom 2000
Jane 3000
Jane 3000
Jane 3000

I want my pivot table to show:
Fred 1000
Tom 2000
Jane 3000

is there a way to remove duplicate data?

right now my pivot table shows:
Fred 3000
Tom 6000
Jane 9000

I don't want the numbers to be summed.

Alternative solutions i have already looked at:
I know I can also do this using Advanced Filtering - which I will do if need
be.
I have also added a new column to my database called "Unique entries" which
i can use for my pivot table - but that's another "manual" thing to do - i
would like to try to work with the existing database - without having to add
more columns and formulas.

appreciate your assistance!
 
You could average the numbers. That would work in the example you posted.
Just change the aggregation of the numbers from sum to average.
 
thanks Jim for that great idea!

Jim Thomlinson said:
You could average the numbers. That would work in the example you posted.
Just change the aggregation of the numbers from sum to average.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to select one record of each from a column 2
Quick Pivot Table Question 2
Pivot Table 2
Need help with a formula 2
How to Sort by Count the Max nos of Unique text values in Pivot Ta 1
Calculated Field in Pivot Table Based On Totals-and hide a data fi 3
Summing like data 5
Need help with a chart 4

Back
Top