This content has been marked as final.
Show 4 replies
-
2. Re: Create YoY Calculation with Hierarchy and Taking Missing Years Into Consideration
Sarah Sidoli Jul 10, 2018 7:56 AM (in response to Shinichiro Murakami)Thank you so much Shin! This worked beautifully.
-
3. Re: Create YoY Calculation with Hierarchy and Taking Missing Years Into Consideration
Shinichiro MurakamiJul 10, 2018 8:00 AM (in response to Sarah Sidoli)
Hi Sarah,
You are very welcome.
Shin
-
4. Re: Create YoY Calculation with Hierarchy and Taking Missing Years Into Consideration
Sarah Sidoli Jul 12, 2018 7:04 AM (in response to Sarah Sidoli)Just a side note, the following helped to remove the rows that did not contain the correct year from the overall calculation so that I was able to get like-for-like YoY change: