Offset Function to get monthly value
Please help how I can get the monthly value from our DATA Collect to a line item in Year format.
In my example screenshot below, I need to pull the Jan 2020 data to the Jan line item. I tried to use offset to get the Jan value but with no luck.
Thanks in advance for helping,
Thanks @anirudh for this. The lookup in the LIS item works.