Change month automatically in pivot table

Salamullah

Board Regular
Joined
Mar 28, 2011
Messages
221
I have many sales pivot tables showing columns of Current year, last year and plans.

Last year and plan data is from Jan to Dec and actuals pasting each month.

Now when I refresh to get YTD Apr results for example I need to select Apr manually in each pivot to change the YTD result

Is there a way pivot table can give results automatically ?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,099,507
Messages
5,469,029
Members
406,628
Latest member
jared92

This Week's Hot Topics

Top