Growth of sales over the Years

[Siddharth476]

I have below data, and I want to use it to generate growth of sales over the years

Input:

Output:

The formula used is [2025]=[Current Sales(2024)]*(1+[Growth Rate])

I have to generate similar data for 20 years so I can't apply formula tool 20 times, any efficient method. 

Thank you so much!

[Bren_Spill2]

Hi @Siddharth476 - please see solution attached. Thanks!

[Siddharth476]

Hey Bren,

I am unable to open the file, could you please share the logic or a screenshot.

[Bren_Spill2 · Accepted solution]

Hi @Siddharth476 - I reattached the workflow above, try it now. Screen shots below as well

 

 

 

[Siddharth476]

Thank you Bren, it worked perfectly!!

Had been searching for solution since yesterday.