Hi there, I have posted an example file to explain what I am trying to do within my pivot table (the file is just a pasted area from my original pivot.
I have a duplicate item on line 9 within the first 2 columns - is there a way of hiding? Normally I could filter out by (blank) - but A9 and B9 are not blank - they are the same as above. I just don't want to display duplicate items in the table
How do you want the output to display without showing duplicate items?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
To just ignore the second duplicate - hide it from the pivot results if possible?
That is not strictly a duplicate. The League information is unique.
Why include the leage field ?
You cannot right click on the value in column C and say hide, because that will hide all other rows where the same entry appears.
You might need to remove it from the data, if thats possible.
Hi,
As per my findings the only way to remove the duplicate item is select the item and by right click hide that entry.
Note: Pivot always provide the unique records, however in this case you just have same records for a different league not the duplicates.
Shekhar Sharma
Ok thanks for your help all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks