Hello,
I'm fairly new to Alteryx and I'm trying to get the hang of it. I'm currently working on a workflow and need some assistance.
So what I am currently doing is trying to see increases of data between years. Below is how the data looks:
Type 2012 2013 2014 2015 2016 2017
Average 78 76 88 110 129 157
What I want it to do is to find the difference for each of those years, but if the amount goes down, to show me a zero. So I want the data to look like this:
Type 2012 2013 2014 2015 2016 2017
Average 78 76 88 110 129 157
Change 0 0 12 22 19 28
Any assistance in this would be highly appreciated. Thank you in advance!
Solved! Go to Solution.
That solved my problem. Thank you so much for your help!