Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask here!
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
