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

[saurav_palekar]

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!

[saurav_palekar]

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. 

[kamal03]

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

[malteryx1]

Please use Multirow Formula