Hi,

I want create a simple pivot table that sum a number amount for each customer.
Each row also have a date field.
The part I am having trouble with is I only want rows whose date is within the last year to be included. I have tried grouping the data by year and in that dialog I can choose a minimum/maximum date. However, its not what I want as the data is being being summed per year, I want all data summed over within the last year from the current date.
So, for the table below, the summed amount should be 11 as the first row is not in the last year,

id balance date
1 6 01/03/09
1 8 03/09/09
1 3 06/02/10

thanks,

Brian