C4C Analytics: Best way to create Previous/Current Year difference columns

Hi C4C Community,

My colleague and I are trying to show a previous/current year comparison view in C4C Analytics.

Basically we need to add columns for (1) difference quantity and (2) difference %. These need to show the difference between the current and previous year. Output similar to the following -

We have managed to do this, using the following -

1. Create a Restricted Key Figure (ZQTY_PREV) based on the previous year
2. Create a Restricted Key Figure (ZQTY_CURR) based on the current year
3. Create a Calculated Key Figure (ZQTY_DIFF) for ZQTY_CURR - ZQTY_PREV
4. Create a Calculated Key Figure (ZQTY_DIFFP) for the ZTY_DIFF % ZQTY_PREV

Is this the best way to approach this or is there an easier way?

Thanks in advance,

Mark