This content has been marked as final. Show 4 replies
Hi. Based on a list of invoices with open and closed dates I'm trying to create a 'snapshot' view as shown in the graph.bmp file below. It should display the age profile of the invoices as they would have been at the end of each month - e.g. at the end of May, show only those invoices that were open in May and how 'old' they were at the time.
All I have to work on is the current list of open and closed invoices to try and recreate the historical views (Invoice list.xlsx).
Can anyone help!?