Skip to Content
1

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

Sep 04, 2017 at 04:39 AM

61

avatar image

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

screen-8518.png (6.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Trivedhi Devavarapu
May 08 at 12:34 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded