TomDrury89
New Member
- Joined
- Aug 22, 2018
- Messages
- 14
Hi All,
I currently have 2 live data sources, essentially money in and money out.
Both data sources have common dates.
I basically want to generate a table that will pull through the dates and then have the columns for in and out and then a balance table for reconciliation purposes. What is the best way forward? I was thinking some kind of combined pivot table?
Both sides could either be 1 or multiple transactions
Mock Desired View
Thankyou !
I currently have 2 live data sources, essentially money in and money out.
Both data sources have common dates.
I basically want to generate a table that will pull through the dates and then have the columns for in and out and then a balance table for reconciliation purposes. What is the best way forward? I was thinking some kind of combined pivot table?
Both sides could either be 1 or multiple transactions
Mock Desired View
| Date | In | Out | balance |
| 01/07/2020 | 100 | -100 | |
| total | 100 | -100 | 0 |
| 01/08/2020 | 50 | -100 | |
| 50 | |||
| Total | 100 | -100 | 0 |
| 01/10/2020 | 100 | -50 | |
| -50 | |||
| Total | 100 | -100 | 0 |
| 01/11/2020 | 100 | ||
| Total | 100 | 100 |
Thankyou !
