Substract actual Value from previous Value under certain conditions

Hi Community,

i have following problem:

Every month i get a table with new Data and i calculate the difference to the previous moth for a list of KPIS.

Is it possible to create a Workflow which says:

  1. In Periode 3 (P03) look for “BU”, “Reporting Unit Name”, “Commodity” and “Consolidation Step”

  2. Search this line in Period 2 (P02)

  3. Calculate the difference for every KPI in an seperate Column.

  4. Do the same with the Data when Periode 4/5/6… is available

Difference Period.xlsx