Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
I have a set of data that includes sales, and gains/losses but i want to adjust the sales based on the gains/losses in order to smooth out spikes and dips in my monthly sales #s.
Been trying to use a multi-row tool to amortize it but it's not working as i want. Below is the original sample data and the expected output:
Any help would be greatly appreciated!
Solved! Go to Solution.
Hi @sheidari
Here's one approach:
- Add record ID, reverse by sorting
- Multi-row to fill in gain/loss of 3M for every record (Multi-row is great for filling down, not so much filling up)
- Sort back and perform the calculation. My numbers are off by 5 which I assume is because your %s have more numbers than are visible.
Let me know if this works for you
