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 ?
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 ?