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

[MarkHowes]

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

[former_member233981 · Accepted solution]

Hi Mark,

Since calendar year cannot be show separately as two columns for current year and previous year. Its the correct way to create restricted key figures by passing restrictions calendar year.

Thanks,

Trivedhi