Hi there Alteryx community! I have a question which I was hoping to get some ideas for.
I am trying to create a single row of data which calculates for me the change in Accounts Receivable (and other working capital line items) on a monthly basis. I am not missing any months, and my data looks like this:
Accounts Receivable Closing Balances per Month
ACCOUNT_NAME | PERIOD_END_DATE | CLOSING |
Accounts receivable | 1/31/2018 | 100 |
Accounts receivable | 2/28/2018 | 200 |
Accounts receivable | 3/31/2018 | 300 |
Accounts receivable | 4/30/2018 | 355 |
Accounts receivable | 5/31/2018 | 410 |
Accounts receivable | 6/30/2018 | 405 |
Accounts receivable | 7/31/2018 | 460 |
I essentially would like my output to look like this:
Account | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 |
Accounts Receivable | 0 | -100 | -100 | -55 | -55 | 5 |
As you can see, my requirements are as follows:
So far I can think of using these tools, but I'm not sure how to put it all together:
Any help is greatly appreciated!
Solved! Go to Solution.
Hi @ImadZidan !
Thank you so much for sharing this solution. I used it in combination with @Emil_Kos 's solution and it worked perfectly!
Thanks for your suggestion @SubratDas5 !