6 Replies Latest reply on Apr 18, 2018 9:07 PM by baron li

    How can I return (lookup) the dimension with the lastest data I have

    baron li

      The data looks like this:

       

      Every week, it will come with new data so next week, there will be a number (not 0) in week 8, etc.

       

      My question is how I can do a lookup to return the right week? In this case, it should be 'Week 7'. Then I need to use this result to get the number of the same week but in another year.