HI,

I have a Pivot Table with a date field as the pivot filter. The data for the pivot table is sorted by date descending. But everyday, when the new data gets updated, the pivot table filter moves the new date not to the top, but after the 1st entry. How do I sort the filter so that it always shows the date descending?


Thanks

WS