Dear Mynda,
Bottom line when the user needs to choose date selection, you ref to Section 5.08.(Combo Box Selection), are we using the Macro w/pivot tables or linking two pivot slicers/charts,......Please advise ASAP!
Cheers!
Valerie
Hi Valerie,
I'm not sure I fully understand your question.
You can control multiple PivotTables in two ways:
1. using the technique shown in session 5.08 where you use VBA/Macro to control multiple PivotTables based on the selection chosen in the Combo Box.
2. using Slicers.
Slicers are only available in Excel 2010 onwards so if you have Excel 2007 then your only option is using VBA as shown in 5.08.
Slicer constraint: if you group your dates in a PivotTable and you want to filter years and months then you'll find you need two Slicers; one for the month and a separate one for the year. This isn't so desirable but there is a workaround explained here: https://www.myonlinetraininghub.com/create-a-single-excel-slicer-for-year-and-month
I hope that answers your question, but if I missed anything please let me know.
Mynda
Thanks Mynda,
The workaround link answers my question!
Much appreciated!....Valerie!
