pivot help - limit data for last 20 dates
 

have two three columns in my source data: date, number, text. i would like
to average the numbers in a pivot table, but i want to limit the numbers
averaged to those from the last 20 dates. any help is appreciated. thanks.