Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a transactions data. I want to create a table having date range with account number and total amount of transactions.
For example:
Data:
Date account Number amount
11-July-19 XYZ 40
11-July-19 ABC 20
12-July-19 XYZ 60
13July-19 XYZ 20
13-July-19 ABC 100
14-July-19 ABC 50
16 July 2019 ABC 40
and so on...
Desired Output for every 5 days interval (Can use a pivot table but unable to get the results):
Date Account Number Amount
11-15 July 2019 ABC 120
11-15 July 2019 XYZ 120
12-16 July 2019 ABC 140
PFA the required output
Varun, did Agni's post and sample app help you get things sorted? If so, please be sure to give them credit by using the Accept as Solution button on the post to mark it. If you did something else, consider posting that and mark it. If you are still working on things, if you can provide an update, others may be able to chime in with other ideas.
Regards,
Brett