Frank Freese
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much
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.
ASKER
Ah well...keep the points :)
ASKER