Sublist function: Unable to retrieve data while using sublis

4.37K viewsScripting


I am trying to retrieve YTD revenue values from LayoutofMonth matrix to Final View Matrix.

I used following formula:

The formula works for the first year 2018. But, I am unable to retrieve the value of revenue from the next year onwards e.g 2019

What am I missing??


Sorry to post this in scripting section. Will post it again in Formula Section. I dont know how to delete a post.