Is there a way to pick the last value of an item in a pivot table? I was
using the Average function, but it's not correct. I need to poll the data
and pick a value based on date field in my data.

Thanks.