Sublist function: Unable to retrieve data while using sublis
Hello,
I am trying to retrieve YTD revenue values from LayoutofMonth matrix to Final View Matrix.
I used following formula:
Revenue=sum(sublist(LayoutofMonth::Year:Month:Revenue,1,#Month))
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??