View Single Post
  #1   Report Post  
Pivot Help
 
Posts: n/a
Default 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.