Add month over month values using growth rates (example 10%)

Hi everyone, I'm new to the Alteryx community!

I would like to add values in a column based on previous value. The next value in the column should be based on the previous value and so on.

I have dates, segment 1, segment 2, and Values as columns.

Some cells in values columns are blank and needs to be filled based on previous date's values by adding 10% growth rate.

Example

Please find the excel file for reference!

Thank you so much!

Month on Month growth.xlsx

Time Series

Accepted answers

Hi @saurav_palekar

This can be achieved using a multi-row formula in Alteryx.

Try the below workflow, Please let me know if this works for you or not.

Add month over month.png

Add month over month.yxzp

@saurav_palekar @kamal03
Just a guess, but maybe we need to group by "Segment 1" and "Segment 2" when using the Multi-row formula tool?

Add month over month.png

yes, @Qiu we can use group by if we need to group by the calculation by column.

Thanks

All comments

Hi @saurav_palekar

This can be achieved using a multi-row formula in Alteryx.

Try the below workflow, Please let me know if this works for you or not.

Add month over month.png

Add month over month.yxzp

@saurav_palekar @kamal03
Just a guess, but maybe we need to group by "Segment 1" and "Segment 2" when using the Multi-row formula tool?

Add month over month.png

yes, @Qiu we can use group by if we need to group by the calculation by column.

Thanks

Hello @kamal03 and @Qiu , thank you for helping me on this, it worked for me.

I have a follow up question, just curios if we have 2 different Segment 1 and Segment 2 combination.

Combination 1 - Segment 1 = ABC and Segment 2 = XYZ growth rate is 10%,

Combination 2 - Segment 1 = XYZ and Segment 2 = DDD growth rate is 15%,

and I want to fill values for remaining dates, how can I do that?

Please find attached sample data file for it.

Thank you so much!

Month on Month growth.xlsx

Hi @saurav_palekar, You just me know check the group by options. Please implement the below configuration setting in your workflow and give it a try.

month over month.png

Hi @kamal03 can you please attach the workflow file for reference?

Would really appreciate it.

Thank you!

sure here is the workflow

Hi Kamal, looks like you shared a different workflow by mistake.

Thanks!

Hi Saurav , sorry about that here is the updated workflow. Please let me know if this is correct or not.

Add month over month.yxzp

Hi Kamal! Sorry, I didn't asked the question correctly, please find the attached data file.

In case of 2 different growth rates - how can I fill the remaining values.

For 'Segment 1 = XYZ and Segment 2 = ABC', the growth rate is '10%'

BUT

For Segment 1 = XYZ and Segment 2 = DDD, the growth rate is '15%'

Basically 2 different growth rates for 2 different combinations.

I have attached the updated file for your reference.

Please let me know if you have any questions regarding this.

Month on Month growth.xlsx

Cool, Here is the updated workflow, please let me know if it works or not.

Here is the formula which you need to write in multirow formula : -

if [Segment 1] ='XYZ' and [Segment 2]='ABC'
then
(if isnull([Values]) then (0.10*[Row-1:Values])+[Row-1:Values]
else
[Values] endif
)
elseif [Segment 1] ='XYZ' and [Segment 2]='DDD'
then
(if isnull([Values]) then (0.15*[Row-1:Values])+[Row-1:Values]
else
[Values] endif
)

else [Values]
endif

Thanks

Add month over month.yxzp

Please use Multirow Formula Screenshot (7).png

Quick Links

Tags

This months top contributors

Hollingsworth 335