This content has been marked as final.
Show 2 replies

1. Re: YoY calculation of running total value.
Zhouyi Zhang Aug 20, 2018 7:20 AM (in response to shaheen.haque.1)Hi, Shaheen
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
ZZ

Test (13)_v10.5.twbx 8.6 KB


2. Re: YoY calculation of running total value.
shaheen.haque.1 Aug 20, 2018 7:50 AM (in response to Zhouyi Zhang)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.731.25)/1.25 ) = 118.4%. I am not able to get this value