Create and fill dependent growth columns

[ArminL]

Hey everybody,

can someone help me how I could create and automatically fill the columns "Abs. growth" and "Rel. growth" in alteryx. 

Only the first three columns are available from my database...

As their is no regularity, I especially don't know how to calculate these new columns fitted to the specific artist. (e.g. i do not want to get a rel growth from 1 month from eminem to 3rd month of Pink)

Artist	Month	Units Sold	Abs. growth	Rel. growth
Pink	1	50
Pink	2	75	25	50%
Pink	3	100	25
Eminem	1	60
Eminem	2	80	20
Eminem	3	100	20
U2	1	25
U2	2	75	50
U2	3	100	25

Thanks in advance :))

[MarqueeCrew · Accepted solution]

@ArminL,

You will use 2 Multi-Row formula tools. 

1. Abs Growth:
   1. Group by Artist

2. [Units Sold]-[Row-1:Units Sold]

   Rel Growth:
   1. Group by Artist
      

      IF [Row-1:Units Sold]> 0 THEN 
      [Abs Growth]/[Row-1:Units Sold]
      ELSE 0
      ENDIF

      Note:  I used this conditional logic to avoid division by 0

Cheers,

Mark