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??
This should get you what you need.
Revenue = sum(sublist(LayoutofMonth::Year:Month:Revenue
, (((#Year-1) * 12) +1 ) //Year Index less 1 * 12 then add 1 to get the first month of the year.
, #Year:Month) )