It seems you already get the the correct calculation, and you just want to hide the rows and only keep the last for each year. If this is correct, please find my solution attached as well as below screenshot for your reference.
Hope this helps
Test (13)_v10.5.twbx 8.6 KB
No i think i was not clear enough. I need another YOY calculation for the data you kept. For 2018 the total value per thousand is 2.73 and for 2017 it is 1.25, so my YOY calculation should be ( (2.73-1.25)/1.25 ) = 118.4%. I am not able to get this value