I need to have the running total of a customer's activity for all months with a balance even for months with no activity. When I use the running total tool, I only get running totals for months with transactions. Additionally, there should be no balance in months prior to a customers first date of activity and no balance in months after they have reached zero and have no activity in that month. I've attached a small file to illustrate.
Solved! Go to Solution.
Hi Alex,
The attached module will show you how to do this. Essentially I have used the generate rows tool to create a row for each month and then filled in the details using a join and multi-row. This does not account for Opening and closing dates but if you Join a table with columns Customer ID, Open Date, Close Date on Customer ID, then you can use a filter tool to remove records or a formula tool to null() records.
You should be able to play with this to get it as Dynamic as you would like.
Kane
Thank you. Very helpful.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |