Hi,

I currently have a Pivot Table report that shows data in rolling 12 months
(12/2004 to 11/2005). Once I refresh the data I get 13 months (12/2004 to
12/2005)and then I go into each pivot and click off the earliest month
(12/2004).

Can anyone help me with a code that would click off the earliest month?

Thanks!