Skip to Content

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

screen-8518.png (6.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 08 at 12:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded