4 Replies Latest reply: Sep 10, 2012 4:59 AM by whiteline _ RSS

    Re-create historical trend from current data

    Kourosh Karimi-Ghovanlou

      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!?