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:
Let me know if this works for you
@Luke_C Thanks for the help. This did the trick!