Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to create growth rates (absolute and relative) depending on two columns?

ArminL
7 - Meteor

As you can probably see from this question, I am pretty new to alteryx. Can somebody tell how to create the last two columns (see attached xlxs) in alteryx by calculating the absolute growth ((Artist: "peter" ; CW "2") MINUS (Artist: "peter" ; CW "1") ) and so on. Same pattern for the relative growth...

 

Thanks in advance and I hope I don't bore you experts :)

2 REPLIES 2
danrh
13 - Pulsar

I don't know that I understand the data, but it sounds like you should look into the Multi-Row Formula tool.  Your workflow might end up looking something like this:

 

image.png

ArminL
7 - Meteor

That works just perfect for the absolute growth. Could you also help me with Relative growth?

Labels