Alteryx Designer Desktop Discussions

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

Dynamically sum previous months based on month selected

GayatriPanigrahi
8 - Asteroid

Hi All,

 

Looking solution for below problem statement. 

 

Based on user selection need to sum previous months value and update upcoming months.

Eg : User has selected month as September then sum the value from Jan till Sep and update Oct, Nov, Dec as 0.

 

I have attached sample data along with example. 

 

Thanks in advance!

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @GayatriPanigrahi 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1641918288137.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @GayatriPanigrahi 

Cheers and have a nice day!

Labels