SAP Analytics Cloud - Calculate Difference of Years in a table

[guenay]

HI Friends,

how can I calculate the difference of a Measure between two specific years?

As you can see for Amount in CC Crcy I have 4 years (2022 is empty). Now my struggle is to calculate the difference between 2021 and 2020.

Some ideas to this?

Kind regards,

Ismail

[Jay_Gandhi · Accepted solution]

Hi guenay,

If you create two restricted measures (one for 2021 and one for 2020) you could easily create a third restricted measure which would simply be Restricted Measure 1 - Restricted Measure 2.

Alternatively, if your above view is static and won't change too much you could create a table calculation by right-clicking the header and inserting a column and create a subtraction calculation such as D2-C2 (as an example).

Creating Calculations from Table Rows or Columns - SAP Help Portal

I would also recommend reviewing this comprehensive blog series on various time calculations that you may find useful: SAP Analytics Cloud In-story Calculation Series – An Introduction | SAP Blogs

Jay