Hi @Rocco 

First Step: You need to Create a Year Property in your 01.2 Year Incurred Dimension and apply following Formula:  

item(if(CUMULATE(1,'01.2 Year Incurred') = if((CUMULATE(1,Year)-19) >0 , CUMULATE(1,Year)-19 ) , Year.'Opening Year'aAdd:'01.2 Year Incurred'])'Remove Textlist:Year],Year)

Second Step: Apply following formula in 03.2 Loss Utilization Dash
 

'03. Future Taxable Income for utilization against available loss'oBy:->'01.2 Year Incurred'.Year]

Hope Your Required View will be achieved in Table.

Hope, I have cleared your query.

Hi there Rocco,

I believe I have a solution for you that will fit what you’re after!

To get started, I would recommend creating a mapping metric where you can hold the mapping between the Year dimension and the Year Incurred dimension. This metric needs only to be dimensioned by Year, with a data type of Year Incurred as shown below:

Once you have this in place, you can then perform a simple mapping by using this metric like so: 

This demonstrates one of the nice uses of the BY: → mapping modifier. This is also quite flexible, as you can generate the values for the mapping by formula, or by manually defining the value - whichever one is more suitable to your business use-case.

I hope this helps, and please let me know if you need any further detail!

-Mat