I have a pivot table which is built off of a data tab that uses an ODBC connection to run a query against our database. This query pulls a running 13 days of data (date between current_date-1 and current_date - 13). So for today (6/7/19) it is pulling data for 5/23-6/6. When I refresh the data tomorrow, the dates will change from to 5/24-6/7. My first question is this: will I need to go into the pivot table and select the new date, 6/7, to be included in the pivot? or will "ALL" days be automatically displayed? I'm trying to ensure that the user(s) of this data DON'T have to interact with the pivots.
Thanks, Dan
Bookmarks