Manually update Label filters on pivot table eventually do this via vba

hi,

I have a file (see enclosed) which has a pivot table. The row lables are a column of dates. What i want to do is somehow only plot dates which are less than or equal to some date "X". For this example lets say X=9/25/12

I dont know how to do this manually or with vba. My longterm goal is to do this with vba but i should know how to do it manually as well.

Any thing you can advise would be helpful!