in this report i have i am wanting to grab the last 6 months at any given time. whenever a new month comes up it adds another month so now there are 7 months in the pivot table. is there anyway i can have it only show the previous 6 months. so if i start in june it shows jan-jun. when july comes around it only shows feb-july in the same cells. thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
pivot table; trailing 6 months
- Thread starter avandever
- Start date
Similar threads
- Question
