Hi Guys,
I have no starting point myself for this so I will just explain what I would like to achieve.
Then maybe someone already did something similar.

So I have two pivots with data that refresh upon importing new data via a macro.
Now the data (and the pivots) also have a field for period.

From a selection box the user can choose the period.
But I also would like to make a checkbox which determines if you want to see the data year to date (YTD) so full year or only the chosen month.

So when the month is lets say November and the YTD checkbox is unticked in the pivot "Period" should be only November/or 11.
But if I then would thick YTD the selection in the pivot would be month 1 till 11, so full year untill November.
Also this macro would logically need to activate upon thicken of the box "YTD".

Anybody any ideas?
Thanks.