Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamically Pick current week data from 53 weeks

Hi All,

 

I have Data for each week starting from Jan to Dec 2019,i want to Pic dynamically the current week data among 53 weeks .

 

Based on the entries in the excel source file ,every week output will get changes.Here i do not have any date field in my source file

 

 

Please find the attached source and output screen shot..

 

 

 

Thanks,

Joshi

 

 

Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous does act_1, act_2.....so on, does these are week numbers?

     

    If yes, does that mean at end of the year it will be act_53/52 depends on the year, correct?

     

    and you want to pick the value from most recent week data is available in the sheet, correct?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for your Time.For all your questions yes is the aswer.

       

       

      Those are week numbers and i want to pick most recent week data out of that

       

       

      Thanks,

      Joshi