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??