Creating pivot table with filtered data

[hfler]

Hi--

I am trying to create a pivot table with data filtered by 'unique entry', but when I highlight the data and create the pivot table, it uses all of the rows, even those that are repeated (i.e. not unique).

How can I make a pivot table and only use the unique entries? Any help would be much appreciated. Thanks!

 

[RoryA]

You could use an advanced filter on the original data to copy the unique rows somewhere else and then base the pivot off that?