Hi,
I'm not looking to add new rows/columns/dimensions in the Quick View. I have and Excel file with existing Quick Views in multiple tabs where I have to change the period every month for each QV. I'm looking to automate the change of period. So far I have been using Find and Replace for the desired period on Excel and going in each QV to click Rebuild but it is time consuming.
This response to me sounds like you want the quick views on multiple tabs to all update to the same period. Without knowing much more than that, would simply setting the time filter to T#Global suffice? Otherwise, the feedback from db_pdx and BobMarchese should get the job done.
I agree with both solutions but there's an obstacle for the case where users have to go back in files dating from previous months and change to a different time function to catch that previous month. There's a risk that a user might omit to change the periods accordingly.
