Hello,
There is a duplicate field in a pivot table with a 2 at its end.
Have ungrouped everything, but cannot get rid of it.
Anyone have a solution ...?
Thanks in advance.
- Mik
Hello,
There is a duplicate field in a pivot table with a 2 at its end.
Have ungrouped everything, but cannot get rid of it.
Anyone have a solution ...?
Thanks in advance.
- Mik
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Appreciate where you're coming from, but it's a huge file that cannot be distributed.
Thank you.
Provide a copy that has been cut down and desensitised, but shows the problem.
NOBODY has asked for you to provide a huge file full of sensitive data.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Understand, have done it many times.
In this particular case it can't be cut down.
Always appreciate everyone's assistance in this forum, if there are general guidelines on this that would be great.
Without even a screenshot of the issue, there won't be a lot anyone can do.
Sounds like you may have two columns in the source data with the same header.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks