Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a scenario wherein, user is filling his details every week. `Let say a user has filled details in Week1, Week2 and Week3. Now if anyone selects Week1, Week2, Week3 then latest week data should be visible i.e Week3. IF user selects Week1, Week2 then again latest week data i.e. week2 data should be selected. It can be the case that User 1 has filled data till week3 and user2 has filled data till week2 and if the selection of Weeks are Week1, Week2, Week3 then for User1, Week3 data should be reflected and for User2 Week2 data should be reflected. Can anyone help em how to achieve this? For your reference attached are the files.
Hi, If last data is fixed (not depending of selections) the better option I think is to set a flag in script to the last record of each user.
Or you can try using FirstsortedValue, like: FirstSortedValue(FieldToShow, -Week)