2 Replies Latest reply on Feb 5, 2019 9:50 AM by Anita Lee

    How to automatically index and sort top 20 movers each week?

    Anita Lee

      I have a list of top-ranking stores last week and a list of most changed week over week. However, at the beginning of each week when new data flows in, the top 20 from last week persist with the updated data. I want the top 20 to rotate each week.

       

      How do I set both views to refresh automatically with the new top 20 and the new most changed, instead of showing the same stores?

       

      Right now, I've been refreshing by removing the filter on Index for top 20, then resorting, then adding back the filter. In the view for top-ranking stores, I also have to manually sort the stores (because when I publish it loses the sort I see in Desktop).

       

      Attaching workbooks below. Any help would be much appreciated!