Pivot Table automation question

[Coldsteel]

I have a question I have a pivot table which has you can drill down by month in it. What I would like to do is click a button and make it select the next month with me selecting it. Example the pivot table is show May's Data I click a button and the the pivot table selects June. Is that possible? Can someone point me in the right direction

 

[noboffinme]

Hi

I'm not sure what you mean as I assume you have the 'Month' field in either the 'Page', 'Row' or 'Column' area of a Pivot Table & you want to select/deselect it.

Can you explain what you want from here?