We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Calculate Previous Year Value in columns

Mahabirpanigrahi
8 - Asteroid
‎03-28-2022 02:17 PM
HI Alteryx Experts, Need your help in calculating Previous Year Value in the column to the table. Have attached the data here, where i have shown my desired output in yellow color. I have tried a long process, thought checking with community for a better/easiest way to build this Appreciate in advance for help. Thanks Mahabir.
Preview file
14 KB
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

10 REPLIES 10
Mahabirpanigrahi
8 - Asteroid
‎04-03-2022 08:55 PM

HI @Kamran1991,

 

You solution is just giving me the previous record value. While I am looking for the previous Yr value for the combination on the file. Example attached. 

Preview file
97 KB
Reply
0 Likes
Labels
Top Solution Authors
View All