Pivot table created

Folks,
In the attached workbook there is a lesson from the "Menu" tab labeled "Combo Box with Macro" There are some instructions on the right side that you're welcome to read. My problem has to deal with the data used in creating the pivot table. Click to "View Raw Data". When you do that the worksheet "Raw Data -2"  appears. When you display the pivot table fields you'll se a field labeled "Years".  I have no idea where that field "Years" came from.
Interactive-Controls.xlsm
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Glenn RayExcel VBA DeveloperCommented:
Those PivotTables are using Grouping to consolidate the Order Date values into months and years.  When Grouping on dates is used new fields like "Years" will appear allowing one to filter on the year values instead.  It also will create two additional filtering values - for dates before or after all dates in the raw data.

So, if you want to get rid of them, you have to first add back the Order Date into the Row Labels for each PivotTable. This isn't possible for the first PivotTable because trying to do that will result in an error
overlap error message
So, you'll have to remove the second PivotTable first, edit the first one and then copy it or re-create the second one.

1) Delete the second PivotTable
2) On remaining PivotTable, select "Order Date" from the fields.  It should drop into the Row Labels box by default.  However, what you'll see are month abbreviations below each Salesperson name - not actual dates!
3) Right-click on any month abbreviation and click "Ungroup".  They will now appear as dates, AND the "Years" field will disappear!
4) Remove the "Order Date" field from the Row Labels.

Regards,
-Glenn
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
Thanks Glenn - I got educated!
0
Frank FreeseAuthor Commented:
Thank you very much
0
Glenn RayExcel VBA DeveloperCommented:
I got some education, too.  I thought I had a solution, then walked away for a bit and started thinking about Calculated Fields..and then realized Groups would do this.
0
Frank FreeseAuthor Commented:
Ah well...keep the points :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.